Pular para o conteúdo principal
Última atualização em

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.

atenção

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, Databricks raises ARITHMETIC_OVERFLOW.

Use try_make_interval to return NULL on overflow.

Common error conditions​

Examples​

SQL
> 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
Nesta página