113. Evaluate the SQL statements:
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 ?0070510
6:00:00 5:
00?)?
Which statement is true?
A. When the New York user selects the row, booking_date is displayed as '0070510
3.00.00.000000'
B. When the New York user selects the row, booking_date is displayed as '20070510
6.00.00.000000
5:
00'.
C. When the San Francisco user selects the row, booking_date is displayed as '0070510
3.00.00.000000'
D. When the San Francisco user selects the row, booking_date is displayed as '0070510
3.00.00.000000 8:
00'
Answer: C
------解决方案--------------------
简单的时区换算