1、获取当前时间

MySQL> select current_timestamp();

→ 2010-01-18 21:24:37 

MySQL> select current_date();  

→ 2010-01-18

MySQL> select current_time();  

→ 21:24:46 

 

2、Unix时间

MySQL> select unix_timestamp();  

→ 1263821184  MySQL> select from_unixtime(1263821182);   → 2010-01-18 21:26:22

 

3、时间前后

MySQL> select date_add(current_timestamp, interval 1 day);  

→ 2010-01-19 21:27:53 MySQL> select date_add(current_time, interval 1 day);   → NULL MySQL> select date_add(current_date, interval 1 day);   → 2010-01-19 MySQL> select date_sub(current_timestamp, interval 1 day);   → 2010-01-17 21:28:41 

#  函数从日期减去指定的时间间隔 和 date_add 对应

MySQL> select date_sub(current_date, interval 1 day);   → 2010-01-17 MySQL> select date_sub(current_time, interval 1 day);   → NULL 

 

4、时间间隔

MySQL> select datediff('2010-01-18','2010-01-17');  

→ 1  MySQL> select timediff('2010-01-18 12:00','2010-01-17 11:00');   → 25:00:00

 

5、时间转换

MySQL> select time_to_sec('25:00:00');  

→ 90000 MySQL> select sec_to_time(90000);   → 25:00:00 

 

Mysql 日期格式化 DATE_FORMATE