CreationTime and LastUpdated in local time instead UTC in InstanceTable

CreationTime and LastUpdated in local time instead UTC in InstanceTable

Postby 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
m.weber.insiders
 
Posts: 2
Joined: Fri 07 Nov 2014 09:32

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

Postby 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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

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

Postby 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
m.weber.insiders
 
Posts: 2
Joined: Fri 07 Nov 2014 09:32

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

Postby 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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

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

Postby 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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle