SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

I-24

Example—Interval Literals

These are all INTERVAL literals:

INTERVAL “1” MONTH An interval of 1 month

INTERVAL “7” DAY An interval of 7 days

INTERVAL “2-7”

YEAR TO MONTH

An interval of 2 years, 7 months

INTERVAL “5:2:15:36.8”

DAY TO FRACTION(1)

An interval of 5 days, 2 hours, 15 minutes, and

36.8 seconds

- INTERVAL “5” DAY An interval that subtracts 5 days