select * from tablename t where t.endtime>to_date('2008080100:00:00','yyyymmddhh24:mi:ss')
上面这个语句错误提示为literal does not match format string
能帮忙解答下哪里错了吗？
------解决方法--------------------------------------------------------
1、如果edntime 为date类型，则不应该有错。
2、如果转化 to_char(sysdate -7,'yyyymmddhh24:mi:ss')) 后插入到一个date字段则会报错。
你的问题场景描述不清楚，可能性很多。
ORA-01861 literal does not match format string
Cause: Literals in the input must be the same length as literals in the format string (with the exception of leading white space). If the "FX" modifier has been toggled on, the literal must match exactly, with no extra white space.
Action: Correct the format string to match the literal.
------解决方法--------------------------------------------------------
应该是endtime列的问题。
