Forum Post: RE: Inconsistency assigning date var to datetime-tz vs. using the date function

  • Thread starter Thread starter Robin Brown
  • Start date Start date
Status
Not open for further replies.
R

Robin Brown

Guest
Sorry for the duplicate post. I hadn’t noticed Fernando’s reply. Robin From: Robin Brown [mailto:bounce-rbrown@community.progress.com] Sent: Tuesday, April 15, 2014 11:53 AM To: TU.OE.Development@community.progress.com Subject: RE: Inconsistency assigning date var to datetime-tz vs. using the date function RE: Inconsistency assigning date var to datetime-tz vs. using the date function Reply by Robin Brown Hi Tom, Per the assignment rules, the datetime-tz is converted to the local date and time for the session's time zone (-04:00), and the time zone is dropped. At midnight on 04/09 in the -03:00 time zone, it is 11pm on 04/08 in the session's time zone. This logic is the same as when you were assigning to a DATE, but the time was also dropped. Robin Stop receiving emails on this subject. Flag this post as spam/abuse.

Continue reading...
 
Status
Not open for further replies.
Back
Top