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')
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')