date_format
This function is used to convert a date into a string based on the format specified by format.
Syntax
date_format(string date, string format)
Parameters
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
date |
Yes |
DATE or STRING |
Date to be converted The following formats are supported:
|
format |
Yes |
STRING |
Format, based on which the date is converted 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, NULL is returned.
Example Code
The value 2023-08-14 is returned.
select date_format('2023-08-14','yyyy-MM-dd');
The value 2023-08 is returned.
select date_format('2023-08-14','yyyy-MM')
The value 20230814 is returned.
select date_format('2023-08-14','yyyyMMdd')
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