which two data types would be affected by this setting?

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?

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

Show Hint

Leave a Reply 9

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

Vonpire

Vonpire

B and E are correct
https://tts.inso.tuwien.ac.at/i/doc/XEDEV/xedev_global006.htm

Reply

Tri

Tri

Thanks Vonpire!

Reply

Tri

Tri

E confirm.

SQL> select * from table_tstz;

C_ID
———-
C_TSTZ
—————————————————————————
1
01-JAN-03 02.00.00.000000 AM -07:00

SQL>

SQL> alter session set NLS_TIMESTAMP_TZ_FORMAT=’YYYY-MMDD’;

Session altered.

SQL> select * from table_ts;

C_ID
———-
C_TS
—————————————————————————
1
01-JAN-03 02.00.00.000000 AM

2
01-JAN-03 02.00.00.000000 AM

SQL> select * from table_tstz;

C_ID
———-
C_TSTZ
—————————————————————————
1
2003-0101

Reply