NexusDB

INTERVAL <interval string> <interval qualifier>

<quote> [ + | - ] { <year-month literal> | <day-time literal> } <quote>

|

years [ -months ]

months

|

<day-time interval>

<time interval>

day [ space hours [ :minutes [ :seconds [.msec] ] ] ]

|

|

hours [ :minutes [ :seconds [.msec] ] ]

minutes [ :seconds [.msec] ]

seconds [.msec]

|

<non-second primary datetime field> TO <primary datetime field>

<primary datetime field>

|

<non-second primary datetime field>

SECOND

|

|

|

|

YEAR

MONTH

DAY

HOUR

MINUTE

Literal Examples

CURRENT_TIMESTAMP + INTERVAL '2' YEAR

CURRENT_TIMESTAMP + INTERVAL '2-6' YEAR TO MONTH

CURRENT_TIMESTAMP + INTERVAL '6' MONTH

CURRENT_TIMESTAMP + INTERVAL '15' DAY

CURRENT_TIMESTAMP + INTERVAL '15 12' DAY TO HOUR

CURRENT_TIMESTAMP + INTERVAL '12' HOUR

CURRENT_TIMESTAMP + INTERVAL '12:25' HOUR TO MINUTE

CURRENT_TIMESTAMP + INTERVAL '12:25:30' HOUR TO SECOND

CURRENT_TIMESTAMP + INTERVAL '25' MINUTE

CURRENT_TIMESTAMP + INTERVAL '25:30' MINUTE TO SECOND

CURRENT_TIMESTAMP + INTERVAL '25:30.254' MINUTE TO SECOND

CURRENT_TIMESTAMP + INTERVAL '21.672' SECOND

SQL:2003 standard

-

Feature F052 "Intervals and datetime arithmetic"