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?