以下的文章主要介绍的是MySQL Date函数的实际应用其中包括如何获取当前时间的具体操作，Unix时间的具体应用，时间前后、时间间隔与时间转换的实际内容描述，以下就是文章的主要内容。

MySQL Date函数 1、获取当前时间

MySQL>selectcurrent_timestamp(); 
+---------------------+ 
|current_timestamp()| 
+---------------------+ 
|2010-01-1821:24:37| 
+---------------------+ 
1rowinset(0.00sec) 
MySQL>selectcurrent_date(); 
+----------------+ 
|current_date()| 
+----------------+ 
|2010-01-18| 
+----------------+ 
1rowinset(0.00sec) 
MySQL>selectcurrent_time(); 
+----------------+ 
|current_time()| 
+----------------+ 
|21:24:46| 
+----------------+ 
1rowinset(0.00sec) 

MySQL Date函数 2、Unix时间

MySQL>selectunix_timestamp(); 
+------------------+ 
|unix_timestamp()| 
+------------------+ 
|1263821184| 
+------------------+ 
1rowinset(0.00sec) 
MySQL>selectfrom_unixtime(1263821182); 
+---------------------------+ 
|from_unixtime(1263821182)| 
+---------------------------+ 
|2010-01-1821:26:22| 
+---------------------------+ 
1rowinset(0.00sec) 

MySQL Date函数 3、时间前后

MySQL>selectdate_add(current_timestamp,interval1day); 
+---------------------------------------------+ 
|date_add(current_timestamp,interval1day)| 
+---------------------------------------------+ 
|2010-01-1921:27:53| 
+---------------------------------------------+ 
1rowinset(0.00sec) 
MySQL>selectdate_add(current_time,interval1day); 
+----------------------------------------+ 
|date_add(current_time,interval1day)| 
+----------------------------------------+ 
|NULL| 
+----------------------------------------+ 
1rowinset,1warning(0.00sec) 
MySQL>selectdate_add(current_date,interval1day); 
+----------------------------------------+ 
|date_add(current_date,interval1day)| 
+----------------------------------------+ 
|2010-01-19| 
+----------------------------------------+ 
1rowinset(0.00sec) 
MySQL>selectdate_sub(current_timestamp,interval1day); 
+---------------------------------------------+ 
|date_sub(current_timestamp,interval1day)| 
+---------------------------------------------+ 
|2010-01-1721:28:41| 
+---------------------------------------------+ 
1rowinset(0.00sec) 
MySQL>selectdate_sub(current_date,interval1day); 
+----------------------------------------+ 
|date_sub(current_date,interval1day)| 
+----------------------------------------+ 
|2010-01-17| 
+----------------------------------------+ 
1rowinset(0.00sec) 
MySQL>selectdate_sub(current_time,interval1day); 
+----------------------------------------+ 
|date_sub(current_time,interval1day)| 
+----------------------------------------+ 
|NULL| 
+----------------------------------------+ 
1rowinset,1warning(0.00sec) 

MySQL Date函数 4、时间间隔

MySQL>selectdatediff('2010-01-18','2010-01-17'); 
+-------------------------------------+ 
|datediff('2010-01-18','2010-01-17')| 
+-------------------------------------+ 
|1| 
+-------------------------------------+ 
1rowinset(0.00sec) 
MySQL>selecttimediff('2010-01-1812:00','2010-01-1711:00'); 
+-------------------------------------------------+ 
|timediff('2010-01-1812:00','2010-01-1711:00')| 
+-------------------------------------------------+ 
|25:00:00| 
+-------------------------------------------------+ 
1rowinset(0.00sec) 

MySQL Date函数 5、时间转换

MySQL>selecttime_to_sec('25:00:00'); 
+-------------------------+ 
|time_to_sec('25:00:00')| 
+-------------------------+ 
|90000| 
+-------------------------+ 
1rowinset(0.00sec) 
MySQL>selectsec_to_time(90000); 
+--------------------+ 
|sec_to_time(90000)| 
+--------------------+ 
|25:00:00| 
+--------------------+ 
1rowinset(0.00sec) 

以上的相关内容就是对MySQL Date函数的介绍，望你能有所收获。

【编辑推荐】

1. MySQL数据库安全设置的操作流程
2. 使用MySQL管理心得讲述
3. MySQL基本操作，新手入门宝典
4. MySQL 操作日志查看的实际操作步骤与代码
5. MySQL游标的使用笔记大全