Versions Compared

Old Version 12

changes.mady.by.user Leonard Xu

Saved on

compared with

New Version 13

changes.mady.by.user Leonard Xu

Saved on

Key

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

...

Currently some temporal function behaviors are wired weird to users. 

  • When users use a PROCTIME() in SQL, the return value of PROCTIME() has a timezone offset with the wall-clock time in users' local time zone, users need to add their local time zone offset manually to get expected local timestamp(e.g: Users in Germany need to +1h to get expected local timestamp). 
  • Users can not use CURRENT_DATE/CURRENT_TIME/CURRENT_TIMESTAMP  to get wall-clock timestamp in local time zone, and thus they need write UDF in their SQL just for implementing a simple filter like WHERE date_col =  CURRENT_DATE. 

...