phoenix日期转化及比较

SELECT TO_CHAR(createtime, 'yyyy-MM-dd HH:mm:ss') FROM test
select * from USER where createtime < TO_TIMESTAMP('2021-11-30 09:00:00.000')

posted @ 2021-12-06 09:06  democ  阅读(456)  评论(0)    收藏  举报