問(wèn)題描述

問(wèn)題解答

那就沒(méi)辦法使用TIMESTAMP了可以考慮使用DATETIME類型

DATE范圍’1000-01-01’ to ’9999-12-31’

DATETIME’1000-01-01 00:00:00’ to ’9999-12-31 23:59:59’

TIMESTAMP ’1970-01-01 00:00:01’ UTC to ’2038-01-19 03:14:07’ UTC

-- N秒前SELECT TIMESTAMPADD(SECOND,-3600,’1970-01-01 00:00:01’)-- >> 1969-12-31 23:00:01-- 2天前SELECT TIMESTAMPADD(DAY,-2,’1970-01-01 00:00:01’)-- >> 1969-12-30 00:00:01# FRAC_SECOND。表示間隔是毫秒# SECOND。秒# MINUTE。分鐘# HOUR。小時(shí)# DAY。天# WEEK。星期# MONTH。月# QUARTER。季度# YEAR。年

確認(rèn)你存的負(fù)數(shù)是相對(duì)于 1970-01-01 00:00:01 的, 如此算并沒(méi)問(wèn)題

select TIMESTAMPADD(FRAC_SECOND, table.create_time, ’1970-01-01 00:00:01’) as `create_time` from table