Back to Materialize

justify_days function

doc/user/content/sql/functions/justify-days.md

123951 B
Original Source

justify_days returns a new interval such that 30-day time periods are converted to months.

Signatures

{{% include-syntax file="examples/sql_functions/justify_days" example="syntax" %}}

ParameterTypeDescription
intervalintervalThe interval value to justify.

Return value

justify_days returns an interval value.

Example

mzsql
SELECT justify_days(interval '35 days');
nofmt
  justify_days
----------------
 1 month 5 days