INTERVAL Syntax - Analytics Database - Teradata Vantage

INTERVAL ( { period_expression | derived_period } ) interval_qualifier

Syntax Elements

period_expression

The Period expression to be converted.

derived_period

Any expression that evaluates to a Period data type.

interval_qualifier

Any interval qualifier appropriate for the argument's element type. The interval qualifiers are as follows:

• Year-Month intervals:
  • YEAR
  • YEAR TO MONTH
  • MONTH
• Day-Time intervals:
  • DAY
  • DAY TO HOUR, MINUTE or SECOND
  • HOUR
  • HOUR TO MINUTE or SECOND
  • MINUTE
  • MINUTE to SECOND
  • SECOND