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
上一篇下一篇

猜你喜欢

热点阅读