Date Time Zone problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Date Time Zone problem

  1. #1
    Join Date
    Oct 2000
    Posts
    3
    Hi,

    can somebody tell me how to solve such a problem.
    We have two databases. One is in Pacific Time Zone,
    another is in Eastern Time Zone. In each database
    we have a table with column of type DATE that store
    record creation time. If I copy data from one database
    to another database across database link then Oracle
    would not convert date from PST to EST automatically.
    So it will look like real record creation time will
    differ in two databases. How can I solve this problem?

    Thanks in advance.

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    Convert the date column with SQL function NEW_TIME.

    NEW_TIME(d, z1, z2), returns the date and time in time zone z2 when date and time in time zone z1 are d.

    SELECT new_time(sysdate,'PST','EST') FROM dual;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width