jplay

Select by Attributes -- Dates

Discussion created by jplay on Apr 17, 2014
Latest reply on Apr 18, 2014 by ccleghorn-esristaff
I need to select from a table all features that have a date stamp of 9999-09-09 in a date feild. Using the Select by attributes function, entering
NC_FLOOD.DBO.L_LEVEE.PAL_DATE = '9999-09-09 00:00:00'
results in "A invalid SQL statement was used."

According to ArcGIS Recourses, NC_FLOOD.DBO.L_LEVEE.PAL_DATE = '9999-09-09 00:00:00' should work for ArcSDE SQL Server, however only the statements for Oracle and Postgre SQL SDE databases seem not to produce the error.
NC_FLOOD.DBO.L_LEVEE.PAL_DATE = date '9999-09-09 00:00:00'

or

NC_FLOOD.DBO.L_LEVEE.PAL_DATE = TIMESTAMP '9999-09-09 00:00:00'

Only those statements don�??t find any results.

Is this a known bug or am I doing something wrong?

EDIT: ArcSDE 10.1, Desktop 10.2.1

Outcomes