WHERE event_type < NOW() - interval '30 days';
"Brian Doyle" <bdoyle@localmatters.com> wrote in message
news:1132269492.30942.20.camel@dev11dt.corp.localmatters.com...
>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
>