timestamp SQL question

From: Brian Doyle <bdoyle(at)localmatters(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: timestamp SQL question
Date: 2005-11-17 23:18:12
Message-ID: 1132269492.30942.20.camel@dev11dt.corp.localmatters.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message codeWarrior 2005-11-17 23:35:48 Re: timestamp SQL question
Previous Message Brian Doyle 2005-11-17 23:00:59