Glue

YYYY-mm-dd HH:MM:SS(.f)

Flink

DATE

• year-month-day
• 2000-01-01

TIME

• hour:minute:second[.fractional]
• 20:00:00.000000000

TIMESTAMP WITH TIME ZONE

• year-month-day hour:minute:second[.fractional] zone
• 2000-01-01 20:00:00.000000000 +09:00

TIMESTAMP_LTZ

• year-month-day hour:minute:second[.fractional] zone
• 2000-01-01 20:00:00.000000000 +09:00

`record_time` TIMESTAMP_LTZ(3)

TIMESTAMP

• year-month-day hour:minute:second[.fractional]
• 2000-01-01 20:00:00.000000000

`time` TIMESTAMP(3)

2023-09-13 18:53:46.010