Specify the format for the Oracle date data type. How does it account for change in century?
Question:
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?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
ANSWER The Oracle date data type is typically formatted as YYYYMMDD HHMISS It automatically acco...View the full answer
Answered By
Churchil Mino
I have been a tutor for 2 years and have experience working with students of all ages and abilities. I am comfortable working with students one-on-one or in small groups, and am able to adapt my teaching style to meet the needs of each individual. I am patient and supportive, and my goal is to help my students succeed.
I have a strong background in math and science, and have tutored students in these subjects at all levels, from elementary school to college. I have also helped students prepare for standardized tests such as the SAT and ACT. In addition to academic tutoring, I have also worked as a swim coach and a camp counselor, and have experience working with children with special needs.
0 Reviews
10+ Question Solved
Related Book For 
Modern Database Management
ISBN: 9780134773650
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman
Question Posted:
