Use of 'interval'

[Tom Allison]

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?

http://www.postgresql.org/docs/faqs/FAQ.html

[Gaetano Mendola]

Tom Allison wrote:

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...

just add them: timestamp + interval = timestamp
Regards
Gaetano Mendola

[Mage]

Tom Allison wrote:

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

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

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