Im struggling to create a query that will pick up dates in a date field. I have tried several versions with ' and " and brackets and all sorts. I'm using the 'Get Unique Values' button to so should be simple?
Field Name: CLOSE_DATE
My Query: CLOSE_DATE = date '1899-12-30 00:00:00'
The Error: There was an error with the expression. Underlying DBMS error [ORA-01861: literal does not match format string][CORPDATA.NSG_Lines]
The data is sitting in Oracle 9i