一、獲取當(dāng)前日期、時間函數(shù)

• now()
• current_timestamp()

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2019-05-15 13:49:03 |
+---------------------+
1 row in set
mysql> select current_timestamp();
+---------------------+
| current_timestamp() |
+---------------------+
| 2019-05-15 14:32:06 |
+---------------------+
1 row in set

二、日期格式與時間戳互相轉(zhuǎn)換

• unix_timestamp() 將日期、時間轉(zhuǎn)換為時間戳
• from_unixtime() 將unix時間戳轉(zhuǎn)換為 日期、時間格式

mysql> select unix_timestamp();
+------------------+
| unix_timestamp() |
+------------------+
|       1557902324 |
+------------------+
1 row in set

mysql> select unix_timestamp('2019-05-01 12:20:20');
+---------------------------------------+
| unix_timestamp('2019-05-01 12:20:20') |
+---------------------------------------+
|                            1556684420 |
+---------------------------------------+
1 row in set

mysql> select from_unixtime(1556684420);
+---------------------------+
| from_unixtime(1556684420) |
+---------------------------+
| 2019-05-01 12:20:20       |
+---------------------------+
1 row in set

三、日期時間計算函數(shù)

• date_add() 給日期增加一個時間間隔
• date_sub() 給日期減去一個時間間隔

mysql> set @dt = now();
Query OK, 0 rows affected

mysql> select date_add(@dt, interval 1 day);
+-------------------------------+
| date_add(@dt, interval 1 day) |
+-------------------------------+
| 2019-05-16 14:50:05           |
+-------------------------------+
1 row in set

date_add(@dt, interval 1 hour)
date_add(@dt, interval 1 week)
date_add(@dt, interval 1 year)

• datediff(date1,date2) 計算兩個日期之間的差值
• timediff(time1,time2) 計算兩個時間點(diǎn)之間的差值

mysql> select datediff('2019-05-15 10:15:30','2019-05-05 13:16:22');
+-------------------------------------------------------+
| datediff('2019-05-15 10:15:30','2019-05-05 13:16:22') |
+-------------------------------------------------------+
|                                                    10 |
+-------------------------------------------------------+
1 row in set

mysql> select timediff('2019-05-15 10:15:30','2019-05-
05 13:16:22');
+-------------------------------------------------------+
| timediff('2019-05-15 10:15:30','2019-05-05 13:16:22') |
+-------------------------------------------------------+
| 236:59:08                                             |
+-------------------------------------------------------+
1 row in set

mysql> select timediff('22:15:30','13:16:22');
+---------------------------------+
| timediff('22:15:30','13:16:22') |
+---------------------------------+
| 08:59:08                        |
+---------------------------------+
1 row in set

先寫這么多，后期會繼續(xù)更新。