Use of 'interval'

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Tom Allison

    #1

    Use of 'interval'

    I'm digging throught the data types and am trying to understand how to
    utilize the interval data type.

    I'm thinking I can use these values to add to another date field...

    Can someone give a simplified example of how I might use this?

    ---------------------------(end of broadcast)---------------------------
    TIP 5: Have you checked our extensive FAQ?



  • Gaetano Mendola

    #2
    Re: Use of 'interval'

    Tom Allison wrote:[color=blue]
    > I'm digging throught the data types and am trying to understand how to
    > utilize the interval data type.
    >
    > I'm thinking I can use these values to add to another date field...[/color]

    just add them: timestamp + interval = timestamp


    Regards
    Gaetano Mendola

    Comment

    • Mage

      #3
      Re: Use of 'interval'

      Tom Allison wrote:
      [color=blue]
      >
      >
      > Can someone give a simplified example of how I might use this?[/color]

      select '2004.12.31. 13:57:42'::time stamp + '3days 52hours';

      Mage


      ---------------------------(end of broadcast)---------------------------
      TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postg resql.org so that your
      message can get through to the mailing list cleanly

      Comment

      Working...