laptop and a wrench

Bug

The ArcPy ArcSDESQLExecute function does not return the date values in ArcGIS for Desktop 10.4.

Last Published: November 30, 2017 ArcGIS for Desktop
Bug ID Number BUG-000096736
SubmittedMay 26, 2016
Last ModifiedAugust 21, 2025
Applies toArcGIS for Desktop
Version found10.4
Version Fixed10.6.0
StatusFixed

Additional Information

Incorrect SQL statement is used. The correct statement is result = conn.execute('SELECT TO_CHAR(DATE_TEST) FROM toolbox.PARKS_3 WHERE OBJECTID_1 = 1') For more information, refer to https://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements004.htm

Steps to Reproduce

Bug ID: BUG-000096736

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options