Skip to content

Feature request for make_interval() #23763

@karenlo-tt

Description

@karenlo-tt

Is your feature request related to a problem? Please describe.

Currently, there is no easy way to create an interval from integer values. The only option that I have found is to first cast those integers into strings.

For example, if I wanted to create an interval of 10 days, I need to run something like:

select format('%s day', some_col)::interval

Describe the solution you'd like

Ideally, we would support the solution provided by Postgres:

make_interval(days => some_col)

As specified here: https://www.postgresql.org/docs/current/functions-datetime.html

Describe alternatives you've considered

No response

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions