Originally posted by gandolf989
SELECT TO_char(date_field) FROM TEST_TABLE Where
TO_char(date_field) > SYSDATE - 1;
Look, left and right expression in where predicate are of different datatypes here.
I wonder what will happen? If right expression implicitly converts to char, then this is wrong.
Bottom line: get rid of this to_char in where clause.
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
Reply With Quote