Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.1.0
    • None
    • SQL
    • None

    Description

      Operator Example Result
      + date '2001-09-28' + interval '1 hour' timestamp '2001-09-28 01:00:00'
      - date '2001-09-28' - interval '1 hour' timestamp '2001-09-27 23:00:00'
      * 900 * interval '1 second' interval '00:15:00'
      * 21 * interval '1 day' interval '21 days'
      * double precision '3.5' * interval '1 hour' interval '03:30:00'
      / interval '1 hour' / double precision '1.5' interval '00:40:00'

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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              yumwang Yuming Wang
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: