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.
Note
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);