Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • SQL
    • None

    Description

      PostgreSQL allows to make an interval by using the make_interval() function:

      make_interval({{years }}int{{ DEFAULT 0, months }}int{{ DEFAULT 0, weeks }}int{{ DEFAULT 0, days }}int{{ DEFAULT 0, hours }}int{{ DEFAULT 0, mins }}int{{ DEFAULT 0, secs }}double precision{{ DEFAULT 0.0)}} interval Create interval from years, months, weeks, days, hours, minutes and seconds fields make_interval(days => 10) 10 days

      See https://www.postgresql.org/docs/12/functions-datetime.html

      Attachments

        Activity

          People

            maxgekk Max Gekk
            maxgekk Max Gekk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: