MySQL日期时间函数总结

7select unix_timestamp('2008-08-08');           -- 1218124800select unix_timestamp('2008-08-08 12:30:00');  -- 1218169800select from_unixtime(1218290027);              -- '2008-08-09 21:53:47'select from_unixtime(1218124800);              -- '2008-08-08 00:00:00'select from_unixtime(1218169800);              -- '2008-08-08 12:30:00'select from_unixtime(1218169800, '%Y %D %M %h:%i:%s %x'); -- '2008 8th August 12:30:00 2008'3. MySQL 时间戳（timestamp）转换、增、减函数：  timestamp(date)                                     -- date to timestamptimestamp(dt,time)                                  -- dt + timetimestampadd(unit,interval,datetime_expr)           --timestampdiff(unit,datetime_expr1,datetime_expr2)   --请看示例部分：  select timestamp('2008-08-08');                         -- 2008-08-08 00:00:00select timestamp('2008-08-08 08:00:00', '01:01:01');    -- 2008-08-08 09:01:01select timestamp('2008-08-08 08:00:00', '10 01:01:01'); -- 2008-08-18 09:01:01select timestampadd(day, 1, '2008-08-08 08:00:00');     -- 2008-08-09 08:00:00select date_add('2008-08-08 08:00:00', interval 1 day); -- 2008-08-09 08:00:00MySQL timestampadd() 函数类似于 date_add()。  select timestampdiff(year,'2002-05-01','2001-01-01');                    -- -1select timestampdiff(day ,'2002-05-01','2001-01-01');                    -- -485select timestampdiff(hour,'2008-08-08 12:00:00','2008-08-08 00:00:00');  -- -12 select datediff('2008-08-08 12:00:00', '2008-08-01 00:00:00');           -- 7MySQL timestampdiff() 函数就比 datediff() 功能强多了，datediff() 只能计算两个日期（date）之间相差的天数。  六、MySQL 时区（timezone）转换函数convert_tz(dt,from_tz,to_tz)select convert_tz('2008-08-08 12:00:00', '+08:00', '+00:00'); -- 2008-08-08 04:00:00时区转换也可以通过 date_add, date_sub, timestampadd 来实现。  select date_add('2008-08-08 12:00:00', interval -8 hour);  -- 2008-08-08 04:00:00select date_sub('2008-08-08 12:00:00', interval  8 hour);  -- 2008-08-08 04:00:00select timestampadd(hour, -8, '2008-08-08 12:00:00');      -- 2008-08-08 04:00:00