mysql中 关于日期的函数 dayname(),dayofweek(),weekday()有什么不同?
mysql> select dayname(now()),dayofweek(now()),weekday(now());
+----------------+------------------+----------------+
| dayname(now()) | dayofweek(now()) | weekday(now()) |
+----------------+------------------+----------------+
| Wednesday | 4 | 2 |
+----------------+------------------+----------------+
1 row in set (0.00 sec)
dayname(),返回的是当前日期是第几个而工作日的英文名,
dayofweek()和weekday()返回的都是当前是第几个工作日,只是前者返回的是从1开始的,即一周的开始是周日,后者返回的是从0开始的,即一周的开始是周一。
weekday更适合东方国家,dayofweek适合于西方国家;
同理我们也可以得到monthname()的用法;
mysql> select monthname(no
+------------------+
| monthname(now()) |
+------------------+
| June |
+------------------+
1 row in set (0.00 sec)