摘要:
下文讲述MySQL数据库中weekday()函数的功能说明,如下所示;
mysql之weekday函数功能说明
weekday函数功能说明:
weekday函数用于返回一个日期在工作日的索引值
weekday函数语法:
weekday(d)
-----参数值说明---
d:必填项
为一个date或datetime值,
当我们输入一个无效的日期值时,则返回NULL
------返回值说明---------
星期一:返回0
星期二:返回1
星期三:返回2
星期四:返回3
星期五:返回4
星期六:返回5
星期一:返回6
mysql之weekday函数示例说明
mysql> select weekday('20200831');
+---------------------+
| weekday('20200831') |
+---------------------+
| 0 |
+---------------------+
1 row in set (0.00 sec)
mysql> select weekday('20200901');
+---------------------+
| weekday('20200901') |
+---------------------+
| 1 |
+---------------------+
1 row in set (0.00 sec)
mysql> select weekday('20200902');
+---------------------+
| weekday('20200902') |
+---------------------+
| 2 |
+---------------------+
1 row in set (0.00 sec)
mysql> select weekday('20200905');
+---------------------+
| weekday('20200905') |
+---------------------+
| 5 |
+---------------------+
1 row in set (0.00 sec)