日期函数(归档按年月日）
参考博客：/shawearn1027/article/details/50901071
时间戳转日期、日期转时间戳
# 时间戳转日期select FROM_UNIXTIME(1663603000,'%Y-%m-%d %T');# 日期转时间戳select UNIX_TIMESTAMP('-12-25 12:25:00')# 字符串转日期select STR_TO_DATE(CURDATE(), '%Y-%m-%d')
常用时间函数
select curdate(); -- 获取当前日期select last_day(curdate());-- 获取当月最后一天。select DATE_ADD(curdate(),interval -day(curdate())+1 day); -- 获取本月第一天select date_add(curdate()-day(curdate())+1,interval 1 month); -- 获取下个月的第一天select DATEDIFF(date_add(curdate()-day(curdate())+1,interval 1 month ),DATE_ADD(curdate(),interval -day(curdate())+1 day)) from dual; -- 获取当前月的天数select date_add(curdate()-day(curdate())+1,interval -1 month); -- 获取上月第一天select last_day(date_add(curdate()-day(curdate())+1,interval -1 month)) -- 获取上月最后一天;
//1.获取年月日 时分秒 select SYSDATE() AS '年月日 时分秒';-07-02 16:36:17//2.获取(年月日)select DATE(CURDATE()) as '年月日';select CURDATE() as '年月日';select current_date AS '年月日';-07-02//3.获取(时分秒)：select time(SYSDATE()) AS '时分秒';select CURtime() AS '时分秒';16:36:17//4.获取年份select YEAR(CURDATE()) AS '年';select YEAR(SYSDATE()) AS '年';select year(CURRENT_DATE) AS '年' ;//5.获取月份select MONTH(CURDATE()) AS '月';select MONTH(SYSDATE()) AS '月';select month(CURRENT_DATE) AS '月';7//6.获取日期中的日 select day(CURRENT_DATE) AS '日';select day(CURDATE) AS '日';select day(SYSDATE) AS '日';3//7.获取当年一月份select CONCAT(YEAR(CURDATE()),'-','01');-07//8.获取当前系统小时：select HOUR(SYSDATE()) AS '系统小时';16//9.获取当前系统分钟：select MINUTE(SYSDATE()) AS '系统分钟';36//10.获取当前系统秒：select SECOND(SYSDATE()) AS '系统秒';17//11.获取当前系统毫秒：select MICROSECOND(SYSDATE()) AS '系统毫秒';0
