OpenAccess SDK supports non-ODBC date, time, and datetime/timestamp formats in pass-through and selective pass-through modes.
The support for these formats is valid for the following:
• DDL statements: SELECT, INSERT, UPDATE, DELETE, and so on.
• Data types: DATE, TIME, and DATETIME.
(For example, {d ‘1999/12/12’}, {t ‘12:32:29:253PM’}, and {ts ‘1998-11-23T11:25:43:250’}.)
For using non-ODBC date, time, and datetime/timestamp formats in pass-through and selective pass-through modes, you must set the IP_INFO_IGNORE_DATETIME_PARSE_ERROR information type to TRUE in the ipGetinfo() function. If not set, OpenAccess SDK throws an invalid date/time literal error. By default, the value is set to FALSE.
For more information, refer to DataDirect OpenAccess SDK™SQL Engine Programmer’s Reference for C/C++, DataDirect OpenAccess SDK™ SQL Engine Programmer’s Reference for Java®, and DataDirect OpenAccess SDK™ Programmer’s Reference for .NET guides.
Note: Before querying, the IP must modify the date/time literals in a way that is understandable by the backend data source.
Examples
DATETIME/TIMESTAMP
INSERT INTO datetime_table values (1, ‘2004-2-28T01:01:01’);
SELECT * FROM datetime_table WHERE dateTimeCol = {ts ‘2004-2-28T01:01:01’};
DATE
INSERT INTO date_table values(1, ‘2012/02/25’);
SELECT * FROM date_table WHERE dateCol = ‘2012/02/25’;
TIME
INSERT INTO time_table values(1, '02:02:02AM');
SELECT * FROM time_table WHERE timeCol = '02:02:02AM';
