Forum Post: Re: Inconsistency Assigning Datetime-tz To Datetime

[gus]

to what is your session:display-timezone set? > On Dec 3, 2015, at 4:10 PM, dbeavon wrote: > > Update from Progress Community [https://community.progress.com/] > > dbeavon [https://community.progress.com/members/dbeavon] > > I did a bit of homework looking for an explanation of the behavior I get when assigning a datetime-tz to a datetime. > > Here is a link of more confusion in a similar vein. > > community.progress.com/.../9423 > > Can someone please run this and tell me if the output line marked with "1" is different from the others for you? For me it is different (OE 11.3). Based on the ABL reference, I think all output lines should show the current time in UTC. (session timezone). > > /* HERE GOES NOTHING */ > > SESSION:TIMEZONE = 0. > > DEFINE VARIABLE vDate1 AS DATETIME. > DEFINE VARIABLE vDate2 AS DATETIME. > DEFINE VARIABLE vDate3 AS DATETIME. > DEFINE VARIABLE vdateTZ AS DATETIME-TZ. > vDateTZ = datetime-tz(NOW,0). > vDate1 = vDateTZ. > vDate2 = NOW. > vDate3 = DATETIME(DATE(vDateTZ), MTIME(vDateTZ)). > > MESSAGE "SESSION NOW" NOW SKIP "SPECIFIED TZ" vDateTZ > SKIP "1" vDate1 SKIP "2" vDate2 SKIP "3" vDate3 > > VIEW-AS ALERT-BOX. > > ┌────────────────── Message ───────────────────┐ > > │ SESSION NOW 12/03/2015 20:40:00.715+00:00 │ > > │ SPECIFIED TZ 12/03/2015 20:40:00.715+00:00 │ > > │ 1 12/03/2015 15:40:00.715 │ > │ 2 12/03/2015 20:40:00.715 │ > > │ 3 12/03/2015 20:40:00.715 │ > > │ ──────────────────────────────────────────── │ > > │ │ > > └──────────────────────────────────────────────┘ > > I am probably going to work on this with Progress tech support for a while but I wondered why I'm the only one having trouble (can't turn anything up from googl'ing). > > Thanks, David > > View online [https://community.progress.com/community_groups/openedge_development/f/19/t/21789] > > You received this notification because you subscribed to the forum. To stop receiving updates from only this thread, go here [https://community.progress.com/community_groups/openedge_development/f/19/t/21789/mute]. > > Flag [https://community.progress.com/community_groups/openedge_development/f/19/t/21789?AbuseContentId=15fe83ea-702e-46c5-9ce7-643e4f5febd3&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true] this post as spam/abuse.

Continue reading...