建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
MySQL Date函數(shù)的正確用法
以下的文章主要介紹的是MySQL Date函數(shù)的實(shí)際應(yīng)用其中包括如何獲取當(dāng)前時(shí)間的具體操作，Unix時(shí)間的具體應(yīng)用，時(shí)間前后、時(shí)間間隔與時(shí)間轉(zhuǎn)換的實(shí)際內(nèi)容描述，以下就是文章的主要內(nèi)容。
網(wǎng)站建設(shè)哪家好，找創(chuàng)新互聯(lián)！專注于網(wǎng)頁設(shè)計(jì)、網(wǎng)站建設(shè)、微信開發(fā)、小程序設(shè)計(jì)、集團(tuán)企業(yè)網(wǎng)站建設(shè)等服務(wù)項(xiàng)目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了太和免費(fèi)建站歡迎大家使用！
MySQL Date函數(shù) 1、獲取當(dāng)前時(shí)間
- MySQL> select current_timestamp();
- +---------------------+
- | current_timestamp() |
- +---------------------+
- | 2010-01-18 21:24:37 |
- +---------------------+
- 1 row in set (0.00 sec)
- MySQL> select current_date();
- +----------------+
- | current_date() |
- +----------------+
- | 2010-01-18 |
- +----------------+
- 1 row in set (0.00 sec)
- MySQL> select current_time();
- +----------------+
- | current_time() |
- +----------------+
- | 21:24:46 |
- +----------------+
- 1 row in set (0.00 sec)
MySQL Date函數(shù) 2、Unix時(shí)間
- MySQL> select unix_timestamp();
- +------------------+
- | unix_timestamp() |
- +------------------+
- | 1263821184 |
- +------------------+
- 1 row in set (0.00 sec)
- MySQL> select from_unixtime(1263821182);
- +---------------------------+
- | from_unixtime(1263821182) |
- +---------------------------+
- | 2010-01-18 21:26:22 |
- +---------------------------+
- 1 row in set (0.00 sec)
MySQL Date函數(shù) 3、時(shí)間前后
- MySQL> select date_add(current_timestamp, interval 1 day);
- +---------------------------------------------+
- | date_add(current_timestamp, interval 1 day) |
- +---------------------------------------------+
- | 2010-01-19 21:27:53 |
- +---------------------------------------------+
- 1 row in set (0.00 sec)
- MySQL> select date_add(current_time, interval 1 day);
- +----------------------------------------+
- | date_add(current_time, interval 1 day) |
- +----------------------------------------+
- | NULL |
- +----------------------------------------+
- 1 row in set, 1 warning (0.00 sec)
- MySQL> select date_add(current_date, interval 1 day);
- +----------------------------------------+
- | date_add(current_date, interval 1 day) |
- +----------------------------------------+
- | 2010-01-19 |
- +----------------------------------------+
- 1 row in set (0.00 sec)
- MySQL> select date_sub(current_timestamp, interval 1 day);
- +---------------------------------------------+
- | date_sub(current_timestamp, interval 1 day) |
- +---------------------------------------------+
- | 2010-01-17 21:28:41 |
- +---------------------------------------------+
- 1 row in set (0.00 sec)
- MySQL> select date_sub(current_date, interval 1 day);
- +----------------------------------------+
- | date_sub(current_date, interval 1 day) |
- +----------------------------------------+
- | 2010-01-17 |
- +----------------------------------------+
- 1 row in set (0.00 sec)
- MySQL> select date_sub(current_time, interval 1 day);
- +----------------------------------------+
- | date_sub(current_time, interval 1 day) |
- +----------------------------------------+
- | NULL |
- +----------------------------------------+
- 1 row in set, 1 warning (0.00 sec)
MySQL Date函數(shù) 4、時(shí)間間隔
- MySQL> select datediff('2010-01-18','2010-01-17');
- +-------------------------------------+
- | datediff('2010-01-18','2010-01-17') |
- +-------------------------------------+
- | 1 |
- +-------------------------------------+
- 1 row in set (0.00 sec)
- MySQL> select timediff('2010-01-18 12:00','2010-01-17 11:00');
- +-------------------------------------------------+
- | timediff('2010-01-18 12:00','2010-01-17 11:00') |
- +-------------------------------------------------+
- | 25:00:00 |
- +-------------------------------------------------+
- 1 row in set (0.00 sec)
MySQL Date函數(shù) 5、時(shí)間轉(zhuǎn)換
- MySQL> select time_to_sec('25:00:00');
- +-------------------------+
- | time_to_sec('25:00:00') |
- +-------------------------+
- | 90000 |
- +-------------------------+
- 1 row in set (0.00 sec)
- MySQL> select sec_to_time(90000);
- +--------------------+
- | sec_to_time(90000) |
- +--------------------+
- | 25:00:00 |
- +--------------------+
- 1 row in set (0.00 sec)
以上的相關(guān)內(nèi)容就是對MySQL Date函數(shù)的介紹，望你能有所收獲。
【編輯推薦】
- MySQL數(shù)據(jù)庫安全設(shè)置的操作流程
- 使用MySQL管理心得講述
- MySQL基本操作，新手入門寶典
- MySQL 操作日志查看的實(shí)際操作步驟與代碼
- MySQL游標(biāo)的使用筆記大全
分享題目：MySQL Date函數(shù)的正確用法
鏈接URL：http://www.dlmjj.cn/article/dpjiids.html
