Re: [SQL] Interval FAQ - please review

2001-08-16 Thread Peter Eisentraut
Josh Berkus writes: > 1. The difference between two TIMESTAMPs is always an INTERVAL > '1999-12-30'::TIMESTAMP - '1999-12-11'::TIMESTAMP = '19 days'::INTERVAL > 2. You may add or subtract an INTERVAL to a TIMESTAMP to produce another > TIMESTAMP: > '1999-12-11'::TIMESTAMP + '19 days':

[SQL] Interval FAQ - please review

2001-08-16 Thread Josh Berkus
Folks, Please review this for inaccuracies before I post it to pgsql-newbie and the docs. -Josh FAQ: Working with Dates and Times in PostgreSQL This FAQ is intended to answer the following questions: Q: Where are the DATEADD() and DATEDIFF() functions in PostgreSQL? Q: How do I tell the amou