Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.0.0
    • Component/s: SQL
    • Labels:
      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

            • Assignee:
              maxgekk Maxim Gekk
              Reporter:
              maxgekk Maxim Gekk
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: