mysql笔记（一）常用日期函数

来源：互联网发布：深圳网站seo 编辑：程序博客网时间：2024/05/22 00:43

入职第三天，mysql数据库，有些手生，整理下常用日期函数

-- 1.当前日期select CURDATE() from dual; -- 2017-07-19select CURRENT_DATE() from dual; -- 2017-07-19-- 2.当前时间（年月日 时分秒级别）select CURRENT_TIMESTAMP() from dual;  -- 2017-07-19 17:13:25select NOW() from dual; -- 2017-07-19 17:47:29-- 3.当前时间（仅时分秒）select CURRENT_TIME() from dual; -- 17:12:46-- 4.当前年份SELECT YEAR(CURDATE()) from dual;  -- 2017-- 5.所在月份SELECT MONTH(CURDATE()) from dual; -- 7-- 6.当前日select DAY(CURDATE()) from dual;  -- 19-- 7.当前月的第一天select date_add(curdate(), interval - day(curdate()) + 1 day);  -- 2017-07-01-- 8.当前月的最后一天SELECT LAST_DAY(CURDATE()) from dual; -- 2017-07-31-- 9.当前季度select QUARTER(CURDATE()) from dual;  -- 3-- 10.1天后 1月后 1年后SELECT ADDDATE(CURDATE(),INTERVAL 1 day) from dual; -- 2017-07-20SELECT ADDDATE(CURDATE(),INTERVAL 1 MONTH) from dual; -- 2017-08-19SELECT ADDDATE(CURDATE(),INTERVAL 1 YEAR) from dual; -- 2018-07-19

阅读全文

0 0