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
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

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