alf Of Bryan (Mailing
> Lists)
> Sent: 17 November 2000 22:34
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] Date arithmatic question
>
>
> 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 so
Bryan (Mailing Lists)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 17, 2000 3:33 PM
Subject: [GENERAL] Date arithmatic question
> I have a table "t" with a timestamp column "s". I am trying to issue a
query
> to find all rows where s is e
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
