划重点
常用的时间占位符 ->%Y-%m-%d %H:%i:%S
一、函数
1、date_format(date, format)
select date_format(now(),'%Y-%m-%d %H:%i:%S');# -10-29 14:02:54
2、unix_timestamp()
select unix_timestamp(now()); # 1509257408
3、str_to_date(str, format)
select str_to_date('-10-29', '%Y-%m-%d %H:%i:%S');# -10-29 00:00:00
4、from_unixtime(unix_timestamp, format)
select from_unixtime(1509257408); # -10-29 14:10:08
转载注明出处: 😃