topic SQL Syntax for table select in Python Questions

SQL Syntax for table select

AndrewRadford1 — Mon, 18 Nov 2013 21:24:44 GMT

Hi i am trying to perform a table select on a file gdb table using the table select tool in python. It is a date field and i can get find the syntax error. I am sure it something simple. any suggestions are appreciated.

arcpy.TableSelect_analysis(table,nt,"date" >= 'date' '2012-01-02 00:00:00' and "date" <= 'date' '2012-01-04 00:00:00'

Thanks!

Re: SQL Syntax for table select

T__WayneWhitley — Sat, 11 Dec 2021 20:41:32 GMT

I think your query for a file gdb needs to be similar to this:
'"date" >= date \'2012-01-02 00:00:00\' and "date" <= date \'2012-01-04 00:00:00\''

So, then this untested snippet:

qry = '"date" >= date \'2012-01-02 00:00:00\' and "date" <= date \'2012-01-04 00:00:00\''
arcpy.TableSelect_analysis(table, nt, qry)