From: codeWarrior <gpatnude@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: timestamp SQL question
Date: Thu, 17 Nov 2005 15:35:48 -0800
Message-ID: <dlj3ve$594$1@news.hub.org> (raw)
References: <1132269492.30942.20.camel@dev11dt.corp.localmatters.com>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gpatnude@hotmail.com
Subject: Re: timestamp SQL question
In-Reply-To: <dlj3ve$594$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox