ODBC Oracle query dates and datetimes

[cosu2004]

Hello guys,

I created an ODBC Oracle db connection and when I make a query for example:

Code: Select all

Select * FROM table;

and this table has columns that are date, datetime types, it gives an error: Unsupported data type. Ok, I understand...but is there a way to avoid this from code or I have to use every time to_char() function in the query !?

Thank you, I'm waiting for an idea.

[alex]

I have to use every time to_char() function in the query !?

Yes. Support for Date, Time and DateTime is in SVN trunk and will be introduced in 1.5. release.