Select to view content in your preferred language

Arcsdesqlexecute from arcpy of desktop 10.5 cannot read date column

2805
10
07-03-2017 01:21 AM
ChrisPedrezuela
Occasional Contributor III

We just recently upgraded from 10.3 to 10.5 and noticed a python script started failing. Based on investigation this class, arcsdesqlexeCute, is causing the issue. For some reason, the returned rows from using this class cannot read date values. Testing on 10.3 arcpy installation, this same workflow runs fine and returns date values properly. Just want to check if this is a bug. Thanks

Tags (4)
0 Kudos
10 Replies
BlakeTerhune
MVP Regular Contributor

We're on Oracle 12c and ArcGIS 10.5.1 and have this problem. Querying a date field either returns an empty string or errors. Had to use to_char() to convert the date to text like Chris Pedrezuela and Vince Angelo mentioned.

0 Kudos