cmcdonald@aberdeen

Definition Query for Dates

Discussion created by cmcdonald@aberdeen on Apr 15, 2010
Latest reply on Apr 26, 2011 by jbanting
Hi,
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
Layer: NSG_Lines
DB: CORPDATA
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

Cheers,
Chris .

Outcomes