Versions Compared

Key

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

...

proposed changes

note

Support function  TO_TIMESTAMP_LTZ(numeric_expr, [,scale])

return type: TIMESTAMP(p3) WITH LOCAL TIME ZONE

#session timezone: UTC

TO_TIMESTAMP_LTZ(44)

1970-01-01 00:00:44 

#session timezone: UTC+8

TO_TIMESTAMP_LTZ(-28756)

1970-01-01 00:00:44

TO_TIMESTAMP_LTZ(numeric_expr [,scale])

TO_TIMESTAMP_LTZ(seconds, 0)

TO_TIMESTAMP_LTZ(milliseconds, 3)TO_TIMESTAMP_LTZ(microSeconds, 6)

TO_TIMESTAMP_LTZ(nanoSeconds, 9)



5.  Support more conversion classes for LocalZonedTimestampType(TIMESTAMP WITH LOCAL TIME ZONE)

...

Due to the historical reason, we didn't not support TIME(9) yet, we think It's a good time point to support it in this FLIP.


8. Introduce 'table.exec.time-function-evaluation' config to control when the time function should be evaluated.(TODO)

an option table.exec.time-function-evaluation to control the materialize time point of time function value. The time function includes

...