toDate

toDate() function is the Standard function available in 200OK.

Description : The toDate function converts the input date into the specified format.

Syntax : fx_toDate(date,yyyy-MM-dd))

Example : fx_toDate(2022-03-31,yyyy-MM-dd) returns "2024-07-03", indicating the date formatted as year-month-day.

Here we go with simple scenario using the above function.

Scenario : In a data management system, users need to convert dates into a standardized format for consistent data processing. They utilize a function to convert dates into the format 'yyyy-MM-dd', ensuring uniformity across datasets. For instance, converting the date '2022-03-31' into 'yyyy-MM-dd' format returns '2024-07-03', facilitating streamlined data analysis and reporting.

Request Side :

Response Side :