...

For example, if user used a UDF which parameter types contains LocalDateTime, and the SQL column data type is TIMESTAMP comes from PROCTIME()/CURRENT_TIMESTAMP, they can migrate to TIMESTAMP WITH LOCAL TIME ZONE smoothly.

6. Support abbreviation name for all timestamp types 

The type name of timestamp is pretty long and inconvenient for users, we can introduce abbreviation for them to make it more convenient.

• TIMESTAMP WITHOUT TIME ZONE               <=> TIMESTAMP_NTZ   which also equals TIMESTAMP
• TIMESTAMP WITH LOCAL TIME ZONE          <=> TIMESTAMP_LTZ  
• TIMESTAMP_WITH TIME ZONE                      <=> TIMESTAMP_TZ 

7. Support TIME(9) for Flink SQL

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.

General Implementations

1.Change the codegen implementations for above five functions/cast conversions according to the value of introduced table option: table.exec.fallback-legacy-time-function

...