Timestamp With Local Time Zone in Direct Mode

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
ndroe
Posts: 18
Joined: Fri 03 Feb 2012 16:08

Timestamp With Local Time Zone in Direct Mode

Post by ndroe » Wed 01 Aug 2012 18:47

I'm using version 7.0.25, and Timestamp With Local Time Zone columns do not appear to work in direct mode.

I'm executing "alter session set time_zone='US/Central'", followed by a query that returns a date. When using direct mode, there is no time conversion. When using the Oracle client, the conversion is made.

Is direct mode supposed to support this?

Thanks,
Nathan

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Timestamp With Local Time Zone in Direct Mode

Post by Pinturiccio » Fri 03 Aug 2012 11:05

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.

ndroe
Posts: 18
Joined: Fri 03 Feb 2012 16:08

Re: Timestamp With Local Time Zone in Direct Mode

Post by ndroe » Fri 03 Aug 2012 18:23

Can you give me an estimate when this will be fixed? I have a release date at the end of the month, and I need to know if I need to work around this issue.

Thanks,
Nathan

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Timestamp With Local Time Zone in Direct Mode

Post by Pinturiccio » Tue 07 Aug 2012 10:58

We are investigating the issue and we will notify you about the results in the nearest future.

ndroe
Posts: 18
Joined: Fri 03 Feb 2012 16:08

Re: Timestamp With Local Time Zone in Direct Mode

Post by ndroe » Thu 23 Aug 2012 11:59

Any updates on this?

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Timestamp With Local Time Zone in Direct Mode

Post by Pinturiccio » Thu 23 Aug 2012 13:27

We have fixed the bug with Local Time Zone not applied for Timestamp With Local Time Zone columns in direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Timestamp With Local Time Zone in Direct Mode

Post by Pinturiccio » Mon 10 Sep 2012 08:05

The new build of dotConnect for Oracle 7.2.77 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=24845

Post Reply