DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=MS8ZEfjSa8kmdiLl0l2P0TUrrHyGCXRUFBn0RoxwWgm3qpxp0JOzkh/eBd4KFmy/j367Vkhr2gwjBvrZtlfV01+DqLGjVRvppk6Ki2zeieC2/H4FlfO5qQMQeJwznWFFT+ud3VWAi62yoUKUQuyhionLKxHNxF2APUY/fsE1Mww=;
Date: Thu, 7 Jun 2007 18:41:21 -0300 (ART)
From: Osvaldo Kussama <osvaldo_kussama@yahoo.com.br>
Subject: Re: subtract a day from the NOW function
To: "Campbell, Lance" <lance@uiuc.edu>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <A3AC4FA47DC0B1458C3E5396E685E63302395E24@SAB-DC1.sab.uiuc.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <276697.3120.qm@web60816.mail.yahoo.com>


--- "Campbell, Lance" <lance@uiuc.edu> escreveu:

> Table
> 
> Field "some_timestamp" is a timestamp.
> 
>  
> 
> In a "WHERE" statement I need to compare a timestamp
> field in a table
> "some_timestamp" to now() - one day.
> 
>  
> 
> Example:
> 
>  
> 
> SELECT some_timestamp WHERE to_char(some_timestamp,
> 'YYYYMMDD') >
> (to_char(now(), 'YYYYMMDD') - 1 day);
> 
>  
> 
> The statement "to_char(now(), 'YYYYMMDD') - 1 day)"
> is obviously
> incorrect.  I just need to know how to form this in
> a way that will
> work.
> 
>  
> 
> If there is an entirely different solution I am all
> for it.  Do note
> that I started down this path because I want to
> exclude the hour,
> minutes and seconds found in the field
> "some_timestamp" and in the
> function now().
> 


Try:
SELECT some_timestamp 
 WHERE some_timestamp > 'yesterday'::timestamp;

Look 8.5.1.5. Special Values at:
http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html

[]s
Osvaldo


____________________________________________________________________________________
Novo Yahoo! Cadê? - Experimente uma nova busca.
http://yahoo.com.br/oqueeuganhocomisso