MYSQL时间函数总结

from_unixtime(&＃39;1436926771&＃39;,&＃39;%Y-%m-%d %H:%i:%s&＃39;)   结果&＃xff1a;   2015-07-15 10:19:31

date_format(&＃39;2008-08-08 22:23:01&＃39;, &＃39;%Y%m%d%H%i%s&＃39;)

str_to_date(&＃39;08/09/2008&＃39;, &＃39;%m/%d/%Y&＃39;); -- 2008-08-09

unix_timestamp(&＃39;2008-08-08 12:30:00&＃39;); -- 1218169800

from_unixtime(1218169800); -- &＃39;2008-08-08 12:30:00&＃39;

date_add(&＃39;2008-08-08 12:00:00&＃39;, interval -8 hour); -- 2008-08-08 04:00:00