mysql日期函数

now() 获取系统时间（年月日时分秒）

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2018-07-03 11:27:06 |
+---------------------+
1 row in set (0.00 sec)

curdate() 获取系统日期（年月日）

mysql> select curdate();
+------------+
| curdate()  |
+------------+
| 2018-07-03 |
+------------+
1 row in set (0.00 sec)

curtime() 获取系统时间（时分秒）

mysql> select curtime();
+-----------+
| curtime() |
+-----------+
| 11:31:14  |
+-----------+
1 row in set (0.00 sec)

date_add() 日期变化，可加可减某个单位

单位有year,month,day,week等，正数加，负数为减

mysql> select date_add('2018-07-03',interval 1 year);
+----------------------------------------+
| date_add('2018-07-03',interval 1 year) |
+----------------------------------------+
| 2019-07-03                             |
+----------------------------------------+
1 row in set (0.00 sec)

datediff() 计算时间差

mysql> select datediff('2018-07-03','2019-07-03');
+-------------------------------------+
| datediff('2018-07-03','2019-07-03') |
+-------------------------------------+
|                                -365 |
+-------------------------------------+
1 row in set (0.00 sec)

date_format() 日期格式化

mysql> select date_format('2018-07-03','%Y/%m/%d');
+--------------------------------------+
| date_format('2018-07-03','%Y/%m/%d') |
+--------------------------------------+
| 2018/07/03                           |
+--------------------------------------+
1 row in set (0.00 sec)

专业墙纸贴纸厨房用具装饰出售，本人网店经营，访问即是爱

博客对你有用记得访问下哦，增加下访问量，如有需要可以下单购买哦^_^。店铺地址https://item.taobao.com/item.htm?id=570637716145