Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

trouble understanding timestamp with local timezone and timestamp with timezone

user1688514Dec 17 2014 — edited Dec 19 2014

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'

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 16 2015
Added on Dec 17 2014
3 comments
898 views