Identifies a field as an INTERVAL value defining a period of time in days, hours, and minutes.
ANSI Compliance
INTERVAL DAY TO MINUTE is ANSI SQL:2011 compliant.
Syntax
INTERVAL DAY [ ( precision ) ] TO MINUTE [ attributes [...] ]
Syntax Elements
- precision
- The permitted range of digits for DAY, ranging from one to four.
- attributes
- Appropriate data type, column storage, or column constraint attributes.