SQLITE 中时间戳转日期

2018-10-17 本文已影响0人 zttjhm

select createtime,content,strftime('%Y-%m-%d',datetime(createtime,'unixepoch','localtime')) as ct from ch_Log where ct = '2017-10-11'