Identifies a field as an INTERVAL value defining a period of time in days and hours.
ANSI Compliance
INTERVAL DAY TO HOUR is ANSI SQL:2011 compliant.
Syntax
INTERVAL DAY [ ( precision ) ] TO HOUR [ 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.