DateTimeOffset broken in 9.5.502

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
denisdbm
Posts: 2
Joined: Mon 18 Jun 2018 21:40

Re: DateTimeOffset broken in 9.5.502

Post by denisdbm » Mon 18 Jun 2018 21:52

Hi @shalex

I'm suffering the same problem in version 9.5.520 (Devart Oracle) with EF Core 2.0.3. I just mapped DateTimeOffset fields using as database typing TIMESTAMP WITH TIME ZONE. The result is an exception, passing an invalid timezone value to an instance of DateTimeOffset (valid values are from -14 to 14).

I'm representing the company which I work. To buy the license, I must confirm if that bug will be resolved, and when (date). To run my software in the production environment, DateTimeOffset is required, and no workarounds, that is, the provider must work as is expected (to preserve investment).

I'm waiting answer. Thanks.

More details:
Oracle version: 12.1 (I need support starting from version 10)
using Direct Mode

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: DateTimeOffset broken in 9.5.502

Post by Shalex » Tue 19 Jun 2018 11:40

@denisdbm
We have answered you by email.

denisdbm
Posts: 2
Joined: Mon 18 Jun 2018 21:40

Re: DateTimeOffset broken in 9.5.502

Post by denisdbm » Tue 19 Jun 2018 15:33

@Shalax,
I've answered your e-mail. Please, see it.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: DateTimeOffset broken in 9.5.502

Post by Shalex » Sat 23 Jun 2018 10:18

The bug with using the OracleDbType.TimeStampTZ parameter when working with Oracle 12.1 in the Direct mode is fixed: viewtopic.php?f=1&t=37342.

@denisdbm
We have received your email and are processing it.

Post Reply