Specify the format for the Oracle date data type. How does it account for change in century? What is the purpose of TIMESTAMP WITH LOCAL TIMEZONE? Suppose the 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 the City A database. How would
Chapter 8, Review question #59
Specify the format for the Oracle date data type. How does it account for change in century? What is the purpose of ‘TIMESTAMP WITH LOCAL TIMEZONE’? Suppose the 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 the City A database. How would the value appear for the City A client and City B client?
This problem has been solved!
Do you need an answer to a question different from the above? Ask your question!
Answer
ANSWER The Oracle date data type is typically formatted as YYYY-MM-DD HH:MI:SS. It automatically acc…View the full answer
Related Book For 
Modern Database Management
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman
ISBN: 9780134773650