Subtracting from a date

From: Andrew Perrin - Demography <aperrin(at)demog(dot)berkeley(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Subtracting from a date
Date: 2000-04-12 17:46:06
Message-ID: Pine.LNX.4.10.10004121040080.12210-100000@famine.DEMOG.Berkeley.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I need to find all records with a date field (date_effective) 3 years or
less prior to now(). This clearly must be possible, but I'm not figuring
it out. Any suggestions?

---------------------------------------------------------------------
Andrew J. Perrin - aperrin(at)demog(dot)berkeley(dot)edu - NT/Unix Admin/Support
Department of Demography - University of California at Berkeley
2232 Piedmont Avenue #2120 - Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-04-12 18:10:50 Re: UNION support for rules
Previous Message Alex Verstak 2000-04-12 17:12:22 UNION support for rules