select
UNIX_TIMESTAMP() as temporary_timestamp, --当前时间的时间戳
UNIX_TIMESTAMP('2011-12-07 13:01:03') as specified_timestamp, --指定时间的时间戳
FROM_UNIXTIME(1568106212) as time_from_timestamp, --来自时间戳的日期
to_date('2011$12&08 13:15:22', 'yyyy$MM&dd HH:mi:ss') as to_date_fun, --将string格式日期转化为日期
dateadd('2019-09-10 17:03:32', -2, 'dd') as date_added --odps中的时间加减结果
from dual;