Overview
Features
Download
Documentation
Community
Add-Ons & Services

ODBC Oracle query dates and datetimes

Please post support and help requests here.

ODBC Oracle query dates and datetimes

Postby cosu2004 » 01 Aug 2012, 14:51

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.
cosu2004
 
Posts: 14
Joined: 05 Jul 2012, 10:50

Re: ODBC Oracle query dates and datetimes

Postby alex » 01 Aug 2012, 14:58

cosu2004 wrote: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.
alex
 
Posts: 1120
Joined: 11 Jul 2006, 16:27
Location: United_States


Return to Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron