You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MMDD.
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
Hi,
B & E are correct.
https://docs.oracle.com/cloud/latest/db121/NLSPG/ch3globenv.htm#NLSPG206:
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
B E