Help Center/
Data Lake Insight/
SQL Syntax Reference (To Be Offline)/
Spark SQL Syntax Reference (Unavailable Soon)/
Built-in Functions/
Date Functions/
weekday
Updated on 2023-10-25 GMT+08:00
weekday
This function is used to return the day of the current week.
Syntax
weekday (string date)
Parameters
Parameter |
Mandatory |
Type |
Description |
---|---|---|---|
date |
Yes |
DATE or STRING |
Date that needs to be processed
The following formats are supported:
|
Return Values
The return value is of the INT type.
![](https://support.huaweicloud.com/intl/en-us/sqlreference-dli/public_sys-resources/note_3.0-en-us.png)
- If Monday is used as the first day of a week, the value 0 is returned. For other weekdays, the return value increases in ascending order. For Sunday, the value 6 is returned.
- 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.
Example Code
The value 2 is returned.
select weekday ('2023-08-16 10:54:36');
The value NULL is returned.
select weekday (null);
Parent topic: Date Functions
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.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot