ODBC to Query Dates

HolesappleBrian
Kilo Explorer

I have a ASP.NET application building an executing a query against a SN instance using the ODBC driver. Can anyone tell me where some advanced documentation is on the use of this driver? I am finding many issues.

First and foremost - A query I am looking to run matches other successful queries in other forum posts:
Select "INC"."number" "Incident_Number", "INC"."active" "Active", "INC"."incident_state" "Incident_State_Code", "INC"."dv_incident_state" "Incident_State_Desc", "INC"."opened_at" "Opened_Date" From incident "INC" Where 1=1 And (("INC"."opened_at" Between '1/1/2012 05:00:00' and '1/31/2012 05:00:00'))

Results in this error:
ERROR [HY000] [DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Error getting the literal value of right operand.[10169]

I dont want to cloud the discussion by mentioning other issues at this time - I may open other forum threads as the need continues.

I am using the SN ODBC Driver - the latest version as of this post.

2 REPLIES 2

HolesappleBrian
Kilo Explorer

Apparently my dates must be formatted as yyyy-mm-dd hh:mm:ss or be wrapped in { d [date value]}
This issue is solved....BTW - The direct data site has the documentation for support functionality with this driver.


got a link to the "documentation for support functionality with this driver" ?