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