问Oracle DB:执行Oracle导出/导入时将时间戳(CET/CEST)列转换为UTC

EN

 FROM_TZ(YOUR_COLUMN, 'Europe/Berlin')  AT TIME ZONE 'UTC'

 SYS_EXTRACT_UTC(YOUR_COLUMN, 'Europe/Berlin')

CREATE OR REPLACE PACKAGE Convert_Date AS       
    FUNCTION TO_UTC(ts IN TIMESTAMP) RETURN TIMESTAMP;
END Convert_Date;
/


CREATE OR REPLACE PACKAGE BODY Convert_Date AS

FUNCTION TO_UTC(ts IN TIMESTAMP) RETURN TIMESTAMP
BEGIN
    RETURN SYS_EXTRACT_UTC(ts, 'Europe/Berlin');    
END;

END Convert_Date;
/

REMAP_DATA=[schema.]tablename.column_name:Convert_Date.TO_UTC