争对日期进行查询的sql写法
select * from CX_STAFF_SAL where created > '2024-03-30 15:56:02'
> ORA-01861: literal does not match format string(出错的)
正确操作利用TO_DATE函数将字符串转化为日期格式:
select * from CX_STAFF_SAL where created > '2024-03-30 15:56:02'
仅自我记录参考
争对日期进行查询的sql写法
select * from CX_STAFF_SAL where created > '2024-03-30 15:56:02'
> ORA-01861: literal does not match format string(出错的)
正确操作利用TO_DATE函数将字符串转化为日期格式:
select * from CX_STAFF_SAL where created > '2024-03-30 15:56:02'
仅自我记录参考