| From: | "codeWarrior" <gpatnude(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: timestamp SQL question |
| Date: | 2005-11-17 23:35:48 |
| Message-ID: | dlj3ve$594$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
WHERE event_type < NOW() - interval '30 days';
"Brian Doyle" <bdoyle(at)localmatters(dot)com> wrote in message
news:1132269492(dot)30942(dot)20(dot)camel(at)dev11dt(dot)corp(dot)localmatters(dot)com(dot)(dot)(dot)
>I have a table like:
>
> events
> visitor_uid varchar(32)
> event_type varchar(32)
> event_type timestamp
>
> I would like to select events from the table that are older than 30 days
> from right now. How would I do that in one query? Thanks.
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dawn Buie | 2005-11-17 23:47:41 | how to do a find and replace |
| Previous Message | Brian Doyle | 2005-11-17 23:18:12 | timestamp SQL question |