Date arithmatic question

From: "Bryan \(Mailing Lists\)" <bryan_lists(at)netmeme(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Date arithmatic question
Date: 2000-11-17 22:33:46
Message-ID: 02ba01c050e6$72f876c0$54ed90cc@netmeme.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

I have a table "t" with a timestamp column "s". I am trying to issue a query
to find all rows where s is exactly some number of days old (rounded off).

I have tried this:

select * from t where date_part('day', age('now', s)) = ?

But this only looks at the day of the month; e.g. if my parameter is "5",
then it will return all rows that are 5 days old, as well as 1 month 5 days,
as well as 2 months 5 days, etc.

I have also tried this:

select * from t where date_part('day', age('now', s)) = ? and
date_part('month', age('now', status_last_update)) = 0

But this restricts my parameter to 30 days or less; greater than 30 days and
the query doesn't return anything.

What is the correct way to express this?

Thank you,

Bryan

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bryan (Mailing Lists) 2000-11-17 22:40:22 Re: Date arithmatic question
Previous Message Matthew 2000-11-17 20:33:08 RE: [GENERAL] Several PostGreSQL questions.

Browse pgsql-general by date

  From Date Subject
Next Message Bryan (Mailing Lists) 2000-11-17 22:40:22 Re: Date arithmatic question
Previous Message Martin A. Marques 2000-11-17 21:48:17 Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL