make_interval function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Creates an interval from years, months, weeks, days, hours, mins and secs.

Warning

This constructor is deprecated since it generates an INTERVAL which cannot be compared or operated upon. Please use make_ym_interval or make_dt_interval to produce intervals.

Syntax

make_interval( [years [, months [, weeks [, days [, hours [, mins [, secs] ] ] ] ] ] ] )

Arguments

  • years: An optional integral number of years, positive or negative.
  • months: An optional integral number of months, positive or negative.
  • weeks: An optional integral number of weeks, positive or negative.
  • days: An optional integral number of days, positive or negative.
  • hours: An optional integral number of hours, positive or negative.
  • mins: An optional integral number of minutes, positive or negative.
  • secs: An optional number of seconds with the fractional part in microsecond precision.

Returns

An INTERVAL.

Unspecified arguments default to 0.

If the result overflows, Azure Databricks raises ARITHMETIC_OVERFLOW.

Use try_make_interval to return NULL on overflow.

Common error conditions

Examples

> SELECT make_interval(100, 11);
 100 years 11 months
> SELECT make_interval(100, null);
 NULL
> SELECT make_interval();
 0 seconds
> SELECT make_interval(0, 0, 1, 1, 12, 30, 01.001001);
 8 days 12 hours 30 minutes 1.001001 seconds

> SELECT make_interval(2147483647, 0);
 Error: ARITHMETIC_OVERFLOW
  • Sist oppdatert