Hi,
I need to export a database containing a table with a timestamp column, the same column in the new database become a timestamp with local time zone column.
The database time zone in the new database is now UTC and the old database time zone is -5:00.
The problem is when I import this table oracle consider the date as UTC because of the way timestamp with local time zone works.
This is obviously wrong because my old data belong to -4:00 or -5:00 depending on the daylight saving.
I know this is an expected behavior but if anyone has already encountered the same situation and found a workaround for this.
Thanks
Cyrille