Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Timestamps stored as UTC time
Fri, May 8 2020 6:06 PMPermanent Link

Richard Harding

Wise Nutrition Coaching

Tim

I store the Creation Timestamp and Modified Timestamp of a row using Before Update and Before Insert triggers.

In EWB2, the time is stored as the local time. In EWB3, it is stored as UTC time. The checkbox "Localize Date/Time columns" is checked in the DataSet configuration.

Richard
Mon, May 11 2020 11:22 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Richard,

<< I store the Creation Timestamp and Modified Timestamp of a row using Before Update and Before Insert triggers.

In EWB2, the time is stored as the local time. In EWB3, it is stored as UTC time. The checkbox "Localize Date/Time columns" is checked in the DataSet configuration. >>

EWB 2.06 Build 20 introduced a breaking change where date or time values are no longer localized, only datetime values:

https://www.elevatesoft.com/download?action=info&category=ewb&type=ewb&majorversion=2&version=2.06

(scroll down to the release notes, at the top)

Tim Young
Elevate Software
www.elevatesoft.com
Image