--开启2.0新类型。此命令需要与SQL语句一起提交。 set odps.sql.type.system.odps2=true; select datetime1, from_utc_timestamp(datetime1,'PST') pst, timestamp1, from_utc_timestamp(timestamp1,'Asia/Shanghai') asia from mf_date_fun_t; ...
set odps.sql.type.system.odps2=true; select datetime1, from_utc_timestamp(datetime1,'PST') pst, timestamp1, from_utc_timestamp(timestamp1,'Asia/Shanghai') asia from mf_date_fun_t; 返回结果如下。 +---+---+---+---+ | datetime1 | pst | timestamp1 | asia | +---+---...
select from_utc_timestamp('2023-08-14 17:00:00','PST'); 返回1691917200000(代表2023-08-13 17:00:00)。 select from_utc_timestamp(date '2023-08-14 00:00:00','PST'); 返回NULL。 select from_utc_timestamp('2023-08-13',null);父...
set odps.sql.type.system.odps2=true; select datetime1, from_utc_timestamp(datetime1,'PST') pst, timestamp1, from_utc_timestamp(timestamp1,'Asia/Shanghai') asia from mf_date_fun_t; 返回结果如下。 +---+---+---+---+ | datetime1 | pst | timestamp1 | asia | +---+---...
set odps.sql.type.system.odps2=true; select datetime1, from_utc_timestamp(datetime1,'PST') pst, timestamp1, from_utc_timestamp(timestamp1,'Asia/Shanghai') asia from mf_date_fun_t; 返回结果如下。 +---+---+---+---+ | datetime1 | pst | timestamp1 | asia | +---+---...