laptop and a wrench

Bug

The ArcSDESQLExecute class does not return Postgres timestamp values in ArcGIS Desktop 10.5 despite having proper conversion function.

Last Published: August 22, 2017 ArcGIS API for Python
Bug ID Number BUG-000106217
SubmittedJune 29, 2017
Last ModifiedJune 5, 2024
Applies toArcGIS API for Python
Version foundN/A
Operating SystemN/A
Operating System VersionN/A
StatusWill Not Be Addressed

Additional Information

This is not an issue in the GP tool. Investigation of the issue also seems to indicate the 'workaround' is how it should be done.

Workaround

Cast the date field to varchar in the SQL query.

Steps to Reproduce

Bug ID: BUG-000106217

Software:

  • ArcGIS API for Python

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options