What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?

The new time and date data types support greater precision for capturing fractional seconds and time zone information. This gives the Oracle database greater flexibility in supporting locality preferences.
What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?

The new time and date data types support greater precision for capturing fractional seconds and time zone information. This gives the Oracle database greater flexibility in supporting locality preferences.
What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?

A.
6 digits

B.
9 digits

C.
12 digits

D.
22 digits

Explanation:
TIMESTAMP[(precision)]
where the optional parameter precision specifies the number of digits in the fractional part of the seconds field. You cannot use a symbolic constant or variable to specify the precision;you must an integer literal in the range0..9.the default is 6

REF: Oracle(r) PL/SQL User’s Guide and Reference, 3-13



Leave a Reply 1

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


seenagape

seenagape

I agree with the answer.