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

  • Thread starter Thread starter Fernando Souza
  • Start date Start date
Status
Not open for further replies.
F

Fernando Souza

Guest
Notice how the NOW function returned a datetime-tz with timezone as -04:00. That is your session's timezone setting. When you converted vDateTZ into a date, as Robin explained, we have to convert it to the session's timezone setting, hence it being one hour earlier, that is, represented in the -04:00 timezone. Does it make sense now?

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