which two data types would be affected by this setting?

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The
default format of which two data types would be affected by this setting?

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The
default format of which two data types would be affected by this setting?

A.
DATE

B.
TIMESTAMP

C.
INTERVAL YEAR TO MONTH

D.
INTERVAL DAY TO SECOND

E.
TIMESTAMP WITH LOCAL TIME ZONE

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Kiran

Kiran

Ans: B and E

NLS_TIMESTAMP_TZ_FORMAT
Property Description
Parameter type String
Parameter scope Initialization parameter, environment variable, and ALTER SESSION
Default value Derived from NLS_TERRITORY
Range of values Any valid datetime format mask

NLS_TIMESTAMP_TZ_FORMAT defines the default date format for the TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE data types. It is used with the TO_CHAR and TO_TIMESTAMP_TZ functions.

Reply