Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Databricks SQL Databricks Runtime 10.4 LTS and above
Creates an interval from days, hours, mins and secs.
Syntax
make_dt_interval( [ days [, hours [, mins [, secs] ] ] ] )
Arguments
days: An integral number of days, positive or negativehours: An integral number of hours, positive or negativemins: An integral number of minutes, positive or negativesecs: A number of seconds with the fractional part in microsecond precision.
Returns
An INTERVAL DAY TO SECOND.
Unspecified arguments are defaulted to 0.
If you provide no arguments the result is an INTERVAL '0 00:00:00.000000000' DAY TO SECOND.
The function is equivalent to executing:
INTERVAL days DAYS + INTERVAL hours HOURS + INTERVAL mins MINUTES + INTERVAL secs SECONDS.
As such each unit can be outside of its natural range as well as negative.
Examples
> SELECT make_dt_interval(100, 13);
100 13:00:00.000000000
> SELECT make_dt_interval(100, null);
NULL
> SELECT make_dt_interval(0, 25);
1 01:00:00.000000000
> SELECT make_dt_interval(0, 0, 1, -0.1);
0 00:00:59.900000000