INTERVAL DAY TO SECOND Data Type

1.    INTERVAL DAY TO SECOND stores a period of time in terms of days, hours, minutes, and seconds.

2.    This data type is useful for representing the precise difference between two datetime values.

Specify this data type as follows:

INTERVAL DAY [(day_precision)]

   TO SECOND [(fractional_seconds_precision)]

 where

day_precision is the number of digits in the DAY datetime field. Accepted values are 0 to 9.

The default is 2.

 fractional_seconds_precision is the number of digits in the fractional part of the SECOND datetime field. Accepted values are 0 to 9.

The default is 6.

 ·       You have a great deal of flexibility when specifying interval values as literals.

·       Refer to Interval Literals for detailed information on specify interval values as literals.