Neoview SQL Reference Manual (R2.4 SP2)

Interval Data Types

Values of interval data type represent durations of time in year-month units (years and months)

or in day-time units (days, hours, minutes, seconds, and fractions of a second).

interval-type is:

INTERVAL[-] { start-field TO end-field | single-field }

start-field is:

{YEAR | MONTH | DAY | HOUR | MINUTE} [(leading-precision)]

end-field is:

[(fractional-precision)]

single-field is:

start-field | SECOND [(leading-precision,

fractional-precision)]

INTERVAL[-] { start-field TO end-field | single-field }

specifies a column that represents a duration of time as a year-month or day-time range or

a single-field. The optional sign indicates if this is a positive or negative integer. If you omit

the sign, it defaults to positive.

If the interval is specified as a range, the start-field and end-field must be in one of

these categories:

{YEAR | MONTH | DAY | HOUR | MINUTE} [(leading-precision)]

specifies the start-field. A start-field can have a leading-precision up to

18 digits (the maximum depends on the number of fields in the interval). The

leading-precision is the number of digits allowed in the start-field. The default

for leading-precision is 2.

specifies the end-field. If the end-field is SECOND, it can have a

fractional-precision up to 6 digits. The fractional-precision is the number

of digits of precision after the decimal point. The default for fractional-precision

is 6.

start-field | SECOND [(leading-precision, fractional-precision)]

specifies the single-field. If the single-field is SECOND, the

leading-precision is the number of digits of precision before the decimal point, and

the fractional-precision is the number of digits of precision after the decimal point.

The default for leading-precision is 2, and the default for fractional-precision

is 6. The maximum for leading-precision is 18, and the maximum for

fractional-precision is 6.

Data Types 239