oracle utc time,如何转化UTC时间为数据库时间?

google ：

https://forums.oracle.com/forums/thread.jspa?threadID=664411

SQL> DROP   TABLE imported_events;

Table dropped.

SQL> CREATE TABLE imported_events (event_date TIMESTAMP(0) WITH TIME ZONE);

Table created.

SQL> BEGIN

2  INSERT INTO  imported_events VALUES ( '10-JAN-08 2:00:00 PM UTC');

3  INSERT INTO  imported_events VALUES ( '08-MAR-08 2:00:00 PM UTC');

4  INSERT INTO  imported_events VALUES ( '09-MAR-08 6:59:00 AM UTC');

5  INSERT INTO  imported_events VALUES ( '09-MAR-08 7:01:00 AM UTC');

6  INSERT INTO  imported_events VALUES ( '09-MAR-08 2:00:00 PM UTC');

7  INSERT INTO  imported_events VALUES ( '10-MAR-08 2:00:00 PM UTC');

8  INSERT INTO  imported_events VALUES ( '09-JUN-08 2:00:00 PM UTC');

9  COMMIT;

10  END;

11  /

PL/SQL procedure successfully completed.

SQL> COLUMN ROWNUM         FORMAT 99

SQL> COLUMN event_date_utc FORMAT A25

SQL> COLUMN offset_local   FORMAT 99

SQL> COLUMN offset_eastern FORMAT 99

SQL> SELECT ROWNUM

2        ,event_date event_date_utc

3        ,TO_CHAR(CAST((event_date AT LOCAL) AS DATE),'YYYY-MM-DD HH24:MI:SS') date_local

4        ,(CAST((event_date AT LOCAL) AS DATE) - CAST(event_date AS DATE))*24 offset_local

5        ,TO_CHAR(CAST((event_date AT TIME ZONE 'US/Eastern') AS DATE),'YYYY-MM-DD HH24:MI:SS') date_eastern

6        ,(CAST((event_date AT TIME ZONE 'US/Eastern') AS DATE) - CAST(event_date AS DATE))*24 offset_eastern

7    FROM imported_events

8   ORDER BY 1;

ROWNUM EVENT_DATE_UTC            DATE_LOCAL          OFFSET_LOCAL DATE_EASTERN        OFFSET_EASTERN

--------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------

--------------

1 10-JAN-08 02.00.00 PM UTC 2008-01-10 10:00:00           -4 2008-01-10 09:00:00             -5

2 08-MAR-08 02.00.00 PM UTC 2008-03-08 10:00:00           -4 2008-03-08 09:00:00             -5

3 09-MAR-08 06.59.00 AM UTC 2008-03-09 02:59:00           -4 2008-03-09 01:59:00             -5

4 09-MAR-08 07.01.00 AM UTC 2008-03-09 03:01:00           -4 2008-03-09 02:01:00             -5

5 09-MAR-08 02.00.00 PM UTC 2008-03-09 10:00:00           -4 2008-03-09 09:00:00             -5

6 10-MAR-08 02.00.00 PM UTC 2008-03-10 10:00:00           -4 2008-03-10 09:00:00             -5

7 09-JUN-08 02.00.00 PM UTC 2008-06-09 10:00:00           -4 2008-06-09 10:00:00             -4

7 rows selected.

SQL>