SELECT
*,
to_char( to_timestamp( statistic_time / 1000 ), 'yyyy-MM-dd HH24:MI:SS' ) AS TIME
FROM
xxx
WHERE
DAY = 20210401
ORDER BY
statistic_time DESC
pg 时间戳转换成时间
最新推荐文章于 2024-04-26 13:29:49 发布
SELECT
*,
to_char( to_timestamp( statistic_time / 1000 ), 'yyyy-MM-dd HH24:MI:SS' ) AS TIME
FROM
xxx
WHERE
DAY = 20210401
ORDER BY
statistic_time DESC