FlinkSQL 时间戳格式化时间

注意时间戳 10位 和 13位 的区别，一个是秒时间戳，一个是毫秒时间戳

select TO_TIMESTAMP(FROM_UNIXTIME(CAST('1706508349552' AS BIGINT) / 1000,'yyyy-MM-dd HH:mm:ss')) as event_time

SELECT TO_TIMESTAMP(FROM_UNIXTIME(1598144693000 / 1000, 'yyyy-MM-dd HH:mm:ss'));
--2020-08-23 09:04:53.000

SELECT TO_TIMESTAMP(FROM_UNIXTIME(1598144693000 / 1000, 'yyyy-MM-dd HH:mm:ss'));
--2020-08-23 09:04:53.000

SELECT TO_TIMESTAMP(FROM_UNIXTIME(CAST('1598231093' AS BIGINT),'yyyy-MM-dd HH:mm:ss'));
--2020-08-24 09:04:53.000

select 
  if(ts is not null, TO_TIMESTAMP(FROM_UNIXTIME(CAST(ts AS BIGINT) / 1000,'yyyy-MM-dd HH:mm:ss')), 
  if(createTime is not null, createTime, TO_TIMESTAMP(FROM_UNIXTIME(UNIX_TIMESTAMP())))) as event_time,