Question

What does the data type INTERVAL DAY(n1) TO SECOND(n2) represent?

a) Represents intervals of days and seconds with precision n1 and n2
b) Represents intervals of years and months with precision n1 and n2
c) Represents intervals of hours and minutes with precision n1 and n2
d) Represents intervals of days only with precision n1

Answer 1

INTERVAL DAY(n1) TO SECOND(n2) is a data type used to represent intervals of days and seconds, where n1 and n2 define the precision of days and seconds respectively.

Step-by-step explanation:

The data type INTERVAL DAY(n1) TO SECOND(n2) represents intervals of days and seconds with precision n1 and n2. The n1 and n2 integers specify the number of digits to store for days and seconds respectively. This data type is particularly useful in database management systems such as SQL where it is needed to store and manipulate periods of time precisely.