Identifies a field as an INTERVAL value defining a period of time in days, hours, and minutes.
INTERVAL DAY TO MINUTE is ANSI SQL:2011 compliant.
INTERVAL DAY [ ( precision ) ] TO MINUTE [ attributes [...] ]
- The permitted range of digits for DAY, ranging from one to four.
- The default is two.
- HOUR is always two digits and MINUTE is always two digits.
- Appropriate data type, column storage, or column constraint attributes.
- See Core Data Type Attributes and Storage and Constraint Attributes for specific information.