Hi,
Could you please explain a bit the difference between timestamp with time zone and timestamp with local timezone?
I am trying to understand why the answer to the question below is C
CREATE TABLE new_order
(orderno NUMBER(4),
booking_date TIMESTAMP WITH LOCAL TIME ZONE);
The database is located in San Francisco where the time zone is -8:00.
The user is located in New York where the time zone is -5:00.
A New York user inserts the following record:
INSERT INTO new_order
VALUES(1, TIMESTAMP ?007-05-10 6:00:00 -5:00?);
Which statement is true?
A. When the New York user selects the row, booking_date is displayed as '007-05-10
3.00.00.000000'
B. When the New York user selects the row, booking_date is displayed as '2007-05-10
6.00.00.000000 -5:00'.
C. When the San Francisco user selects the row, booking_date is displayed as '007-05-10
3.00.00.000000'
D. When the San Francisco user selects the row, booking_date is displayed as '007-05-10
3.00.00.000000 -8:00'