Re: timestamp SQL question

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
>