Versions Compared

Old Version 46

changes.mady.by.user Ganesh Munusamy

Saved on

compared with

New Version Current

changes.mady.by.user Wayne Taylor

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
linenumberstrue
SELECT TD_DATE_TRUNC('day', time, 'PST') FROM tbl

the function returns 1416758400 because 1416729600 because the start of the day for the ‘PST’ timezone is 8 hours behind the start of the day for ‘UTC’.

...