SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
I-23
INTERVAL Literals
days
is an unsigned integer that specifies a number of days. It can have up to 18 digits,
minus the number of digits in the other fields of the INTERVAL literal. Negative
values are allowed, with the minus sign inside the quotes.
hours
is an unsigned integer that specifies a number of hours. Used as a starting field, it
can have up to 18 digits, minus the number of digits in the other fields of the
INTERVAL literal; as a nonstarting field, it must be in the range 0 through 23.
Negative values are allowed, with the minus sign inside the quotes.
minutes
is an unsigned integer that specifies a number of minutes. Used as a starting field,
it can have up to 18 digits, minus the number of digits in the other fields of the
INTERVAL literal; as a nonstarting field, it must be in the range 0 through 59.
Negative values are allowed, with the minus sign inside the quotes.
seconds
is an unsigned integer that specifies a number of seconds. Used as a starting field,
it can have up to 18 digits, minus the number of digits in the other fields of the
INTERVAL literal; as a nonstarting field, it must be in the range 0 through 59.
Negative values are allowed, with the minus sign inside the quotes.
fraction
is an unsigned integer that specifies a fraction of a second. Used as a starting field,
it can have up to 18 digits; as an ending field, it is limited to the number of digits
specified by precision.
start-field [ (digits) ] [ TO end-field]
specifies the range of INTERVAL fields in the literal and the number of digits
allowed in the starting field. The default for digits is 2. (For more information
about INTERVAL fields, see INTERVAL Data Type on page I-19.)
precision
is an unsigned integer in the range 1 to 6 that specifies the number of significant
digits in the portion of the literal that specifies the fraction of a second. The default
is 6.