mysql函數(shù)unix_timestamp如何處理1970.1.1以前的數(shù)據(jù)?
問(wèn)題描述
問(wèn)題解答
回答1:那就沒(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
回答2:-- 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
相關(guān)文章:
1. golang - 用IDE看docker源碼時(shí)的小問(wèn)題2. docker-compose中volumes的問(wèn)題3. dockerfile - [docker build image失敗- npm install]4. angular.js - angular內(nèi)容過(guò)長(zhǎng)展開(kāi)收起效果5. 兩個(gè)思路:python模擬登陸頁(yè)面和模擬操作windows程序窗口提交請(qǐng)求6. 點(diǎn)選多選問(wèn)題7. jupyter-notebook - Mac下啟動(dòng)jupyter notebook后沒(méi)有Python的選項(xiàng)?8. angular.js - angularjs官網(wǎng)Demo quickstart-master在win10系統(tǒng)中啟動(dòng)時(shí)報(bào)錯(cuò)9. android - 如何實(shí)現(xiàn)QQ pad 點(diǎn)擊右側(cè)輸入框,只頂右側(cè)的布局,左側(cè)布局不動(dòng)10. 用Python調(diào)用api之后,沒(méi)有輸出該如何解決?

網(wǎng)公網(wǎng)安備