CreationTime and LastUpdated in local time instead UTC in InstanceTable

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
m.weber.insiders
Posts: 2
Joined: Fri 07 Nov 2014 09:32

CreationTime and LastUpdated in local time instead UTC in InstanceTable

Post by m.weber.insiders » Fri 07 Nov 2014 09:43

Hi.
I'm using dotConnect for Oracle to persist workflows.
I have the problem, that the dates in CREATIONTIME and LASTUPDATED are in local time instead of UTC.

Any ideas how to solve this problem?
Thanks for your help.

Greetings

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

Re: CreationTime and LastUpdated in local time instead UTC in InstanceTable

Post by Shalex » Fri 07 Nov 2014 17:13

Thank you for your report. We will update the \WF Services\OracleInstanceStoreLogic.sql and \WF Services\NET45\OracleInstanceStoreLogic45.sql scripts which are provided with dotConnect for Oracle installation to store UTC instead of local time and notify you.

m.weber.insiders
Posts: 2
Joined: Fri 07 Nov 2014 09:32

Re: CreationTime and LastUpdated in local time instead UTC in InstanceTable

Post by m.weber.insiders » Wed 12 Nov 2014 09:58

Hi.
Do you have an idea, when this issue is going to be fixed? A customer is waiting for this fix.

Greetings

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: CreationTime and LastUpdated in local time instead UTC in InstanceTable

Post by MariiaI » Wed 12 Nov 2014 11:39

m.weber.insiders wrote:Hi.
Do you have an idea, when this issue is going to be fixed? A customer is waiting for this fix.
Greetings
We have fixed this issue. The fix will be included in the next public build of dotConnect for Oracle, which we plan to release in about 1-2 weeks. We will inform you when it is available for download.

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

Re: CreationTime and LastUpdated in local time instead UTC in InstanceTable

Post by Shalex » Thu 20 Nov 2014 17:29

The behaviour is changed in the new (8.4.293) build of dotConnect for Oracle: SYS_EXTRACT_UTC(SYSTIMESTAMP) is used now in WF Services scripts for the date columns.

Post Reply