mysql 函数

🧙 Questions

• string转date
• date转string
• 时间格式
• 日期加时间

☄️ Ideas

string转date

• STR_TO_DATE(str,format)

select str_to_date('2020-12-01 12:12:12','%Y-%m-%d %H:%i:%s') from dual

date转string

• DATE_FORMAT(date,format)

select date_format(now(),'%Y-%m-%d %H:%i:%s') from dual

date转为天数

select cast((unix_timestamp(now()) / 60 / 60 / 24) as signed) from dual;

时间格式

Specifier	Description
%H/%k	Hour (00..23)
%d	Day of the month, numeric (00..31)
%e	Day of the month, numeric (0..31)
%h/%I/%l	Hour (01..12)
%i	Minutes, numeric (00..59)
%j	Day of year (001..366)
%M	Month name (January..December)
%m	Month, numeric (00..12)
%S/%s	Seconds (00..59)
%T	Time, 24-hour (hh:mm:ss)
%Y	Year, numeric, four digits
%y	Year, numeric (two digits)

日期加时间

• DATE_ADD(date,INTERVAL expr unit), DATE_SUB(date,INTERVAL expr unit)

当前时间加一天

select DATE_ADD(now(), INTERVAL 1 DAY) from dual

🔗 Links

• mysql website
• mysql docs
• mysql date type docs
• mysql date function docs