FAQ: Can ArcMap Execute Queries Based on Date and Time Values in Oracle Date Fields?

Answer

Yes. Oracle provides a TO_DATE function. Use the TO_DATE function in the Select by Attribute dialog box to format date strings into date literals. The syntax for this function is:

Code:
TO_DATE(string[,'format'])

Below is an example of a properly formatted WHERE clause. This will select all records having a date/time >= 12/20/2004 2:00 PM:

Code:
MYDATE >= TO_DATE('2004-12-20 14:00:00 ','YYYY-MM-DD HH24:MI:SS')

Oracle supports a wide variety of date/time formats for query and display purposes. Consult the Oracle documentation for further information on formatting dates and times.

Article ID:000006980

Software:

ArcMap 8 x
ArcMap 9 x
Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Properly format an SQL expression to make selections in joined layers and tables

Can ArcMap execute queries based on date and time values in Oracle Date fields?

Answer

Related Information

Discover more on this topic