Select Records by Date
936028May 16 2012 — edited May 16 2012I'm trying to do something pretty simple in Oracle 10G, but getting really annoying as it's not working. I'm just trying to select all records with a specific date. In the table the date has a datatype of date and the value is '18/01/02'. When I execute this statement in Oracle SQL Developer or sqlplus it does not work: and returns no records:
SELECT * FROM SDE.fuse_h WHERE DATECREATED = '18/01/02';
In SqlPlus I do get the message:
ORA-01843: not a valid month
But, I've tried every combination possible!
Edited by: 933025 on May 16, 2012 12:03 AM