Date type

[mlazlo]

Using AcuOdbc 5.2
Attempting to access a table that has a column that is of type date. When I attempt to filter data based on this column it does not work as with other ODBC drivers. Ex.
Select * from plsps
Where DATE_SHIPPED = '2003-08-15'

Are dates handled differently than a ODBC driver for Oracle or MSSql?
Thanks in advanced?

 

[SteveS815]

AcuODBC is used to access data in Vision Files using ODBC compliant programs (MS Access, Crystal Reports...). The Vision Files look like database files to the querying program but they are not. They are "Cobol data files" and there is no data type "date" in a cobol file. Unless the data in the field actually contains the format you mentioned "2003-08-15" (which by total co-incidence is my birthday) you will not get a proper response. Are you sure it's not just a numeric field like 20030815?

 

[mlazlo]

I found the information on how to access a date type through the AcuOdbc:

WHERE DATE_SHIPPED = {d '2003-08-15'}

this now allows access to this column.
thanks for the response.