duration_null() -> duration

Returns a null value of type duration.

This is important because some functions, like case(), return more convenient outputs if all their arguments are of the same type.

Domain

This is a scalar function (calculates a single output value for a single input row).

Examples

Create a column 'positive_or_null' which is either a positive duration, or the null duration.