plsql
-- 时间戳转换为unix格式
FUNCTION timestamp_to_unix(p_time TIMESTAMP,
in_src_tz IN VARCHAR2 DEFAULT '+08:00')
RETURN NUMBER IS
BEGIN
RETURN round((CAST((from_tz(p_time, in_src_tz) at TIME ZONE 'GMT') AS DATE) -
to_date('01.01.1970', 'dd.mm.yyyy')) * (24 * 60 * 60 * 1000)); -- 精确到毫秒级
END;