from_unixtime
将Unix时间戳转化为日期格式
> SELECT from_unixtime(1460041200, 'yyyy-MM-dd');
2016-04-07
unix_timestamp
返回一个Unix时间戳
> SELECT unix_timestamp('2016-04-08');
1460041200
to_date
返回日期
>SELECT to_date('2009-07-30 04:17:52');
2009-07-30
datediff
两个日期相差的天数
date_add/date_sub
指定日期加减天数后返回的日期
其他函数
>SELECT year('2009-07-30 04:17:52'),month('2009-07-30 04:17:52'),day('2009-07-30 04:17:52'),dayofmonth('2009-07-30 04:17:52');
2009 7 30 30
>SELECT hour('2009-07-30 04:17:52'),minute('2009-07-30 04:17:52'),second('2009-07-30 04:17:52'),weekofyear('2009-07-30 04:17:52');
4 17 52 31