to_date1
This function is used to convert a string in a specified format to a date value.
Similar function: to_date. The to_date function is used to return the year, month, and day in a time. The date format cannot be specified.
Syntax
to_date1(string date, string format)
Parameters
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
date |
Yes |
STRING |
String to be converted
The following formats are supported:
|
format |
Yes |
STRING |
Format of the date to be converted Constant of the STRING type. Extended date formats are not supported. The value is a combination of the time unit (year, month, day, hour, minute, and second) and any character.
|
Return Values
The return value is of the STRING type.
- If the value of date is not of the DATE or STRING type, the error message "data type mismatch" is displayed.
- If the value of date is of the DATE or STRING type but is not in one of the supported formats, NULL is returned.
- If the value of date is NULL, NULL is returned.
- If the value of format is NULL, a date in the yyyy-mm-dd format is returned.
Example Code
The value 2023-08-16 10:54:36 is returned.
select to_date1('2023-08-16 10:54:36','yyyy-mm-dd hh:mi:ss');
The value 2023-08-16 00:00:00 is returned.
select to_date1('2023-08-16','yyyy-mm-dd');
The value NULL is returned.
select to_date1(null);
The value 2023-08-16 is returned.
select to_date1('2023-08-16 10:54:36');
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot