mysql date函数
mysql中date函数是什么,怎么使用呢?不知道的小伙伴来看看小编今天的分享吧!
1、date函数简介:
MySQL数据库Date()日期函数,用于MySQL数据库查询当前日期,时间。
2、用法:
获取当前时间:
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)
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>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>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>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)
以上就是小编今天的分享了,希望可以帮助到大家。
声明:本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。