How to query a odbc datasource with field named date
Posted: Mon Mar 20, 2017 12:34 pm
hi,
my odbc datasource has a field with name "date". I get error "... Syntax error in SQL statement at or about "date FROM PUB.my_table" (10713)
i tried to manually the query using several combinations like:
SELECT my_table.date FROM PUB.my_table
SELECT [date] FROM PUB.my_table
tried, SELECT 'date' FROM PUB.my_table - but it threw me a separate batch of errors, it seems that the value is being converted to character as being read, and to date again before being written.
Any ideas how to do this?
Thanks!
my odbc datasource has a field with name "date". I get error "... Syntax error in SQL statement at or about "date FROM PUB.my_table" (10713)
i tried to manually the query using several combinations like:
SELECT my_table.date FROM PUB.my_table
SELECT [date] FROM PUB.my_table
tried, SELECT 'date' FROM PUB.my_table - but it threw me a separate batch of errors, it seems that the value is being converted to character as being read, and to date again before being written.
Any ideas how to do this?
Thanks!