sqlite select中date格式化
2019-03-07 本文已影响0人
wasdzy111
SELECT
*
FROM
(
SELECT
accounts.autoId,
accounts.uUUID,
accounts.title,
accounts.type,
date(
(accounts.createTime / 1000),
'unixepoch'
) AS createTime,
accounts.money,
accounts.remark
FROM
accounts
)
WHERE
createTime > 2019-03-06