What is the purpose of timestamp with local timezone


Problem

In modern database management 12th edition by Hoffer 5-43: Specify the format for Oracle date data type. How does it account for change in century? What is the purpose of 'TIMESTAMP WITH LOCAL TIMEZONE'? Suppose system time zone in database in City A =-9:00 and city B=-4:00. A client in city B inserts TIMESTAMP "2004-6-14 7:00:00 -4:00" in city A database. How would the value appear for city A client and city B client?

Request for Solution File

Ask an Expert for Answer!!
Other Subject: What is the purpose of timestamp with local timezone
Reference No:- TGS03240266

Expected delivery within 24 Hours