to_date
This function is used to return the year, month, and day in a time.
Similar function: to_date1. The to_date1 function is used to convert a string in a specified format to a date value. The date format can be specified.
Syntax
to_date(string timestamp)
Parameters
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
timestamp |
Yes |
DATE STRING |
Time to be processed
The following formats are supported:
|
Return Values
The return value is of the DATE type, in the yyyy-mm-dd format.
- If the value of timestamp is not of the DATE or STRING type, the error message "data type mismatch" is displayed.
- If the value of timestamp is of the DATE or STRING type but is not in one of the supported formats, NULL is returned.
Example Code
The value 2023-08-16 is returned.
select to_date('2023-08-16 10:54:36');
The value NULL is returned.
select to_date(null);
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