Postgres Pro
Downloads
Home   >   mailing lists

timestamp SQL question - Mailing list pgsql-sql

From Brian Doyle
Subject timestamp SQL question
Date
Msg-id 1132269492.30942.20.camel@dev11dt.corp.localmatters.com
Whole thread Raw
Responses how to do a find and replace
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Geographic Distance Calc website
Next
From: "codeWarrior"
Date:
Subject: Re: timestamp SQL question