If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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?