Phoenix中的timestamp字段查询以及timestamp的比较查询
1 查询语法
SELECT TO_CHAR(createtime, 'yyyy-MM-dd HH:mm:ss') FROM USER
2 需要比较timestamp的语法查询
select * from USER where createtime < TO_TIMESTAMP('2017-08-30 06:21:46.732')
1 查询语法
SELECT TO_CHAR(createtime, 'yyyy-MM-dd HH:mm:ss') FROM USER
2 需要比较timestamp的语法查询
select * from USER where createtime < TO_TIMESTAMP('2017-08-30 06:21:46.732')