In my DB,
select DbTimeZone from dual;
gives
DBTIMEZONE
----------
+00:00
and,
select SessionTimeZone from dual;
gives
SESSIONTIMEZONE
---------------------------------------------------------------------------
Asia/Calcutta
I have read that this DbTimeZone is used only for DB columns with TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE data types.
What does DbTimeZone +00:00 mean?? Does this mean GMT???
We have 2 applications. We want to transfer data from DB A to DB B. The DbTimeZone in the DB A is GMT, while the DbTimeZone in the DB B is CST. There are about 50 table columns with type TIMESTAMP.
The transfer of data happens through an application, and not through an Oracle process like a stored procedure or export import method.
The problem is that, when the data is transferred, the application B's tables get a time value 1 hour ,ore than the value in DB A. i.e. if the time component in DB A is 14:57, when transferred, in application B, it is 15:57.
I don't think this has anything to do with Oracle automatically doing anything to the columns, since the columns are just plain TIMESTAMP columns.
Isn't it the application that is doing the transfer that is changing the time and inserting records with this new value???
Can you provide an example where a column with TIMESTAMP WITH TIMEZONE is changed automatically by oracle when transferring??