Mysql Date 函数

为什么80%的码农都做不了架构师？>>>   

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 http://my.oschina.net/grubby/blog/627297

转载于:https://my.oschina.net/grubby/blog/688423