Re: [despammed] Re: Need clarification

am  23.05.2005, um 16:31:55 +0530 mailte palanivel.kumaran@scandent.com folgendes:
> 
> 
> 
> 
> Sorry, I didn't get ur point...please, tell me exact query to extract the
> rows from a table A which contains a date field named DTE  whose difference
> is 30 days as compared to the current date...


test=# create table datediff (start date);
CREATE TABLE
test=# insert into datediff values ('1966/08/30');
INSERT 153382679 1
test=# insert into datediff values ('2005/05/23');
INSERT 153382680 1
test=# select * from datediff ;  start
------------1966-08-302005-05-23
(2 Zeilen)

test=# select * from datediff where CURRENT_DATE - start > 10;  start
------------1966-08-30
(1 Zeile)

test=# select * from datediff where CURRENT_DATE - start < 10;  start
------------2005-05-23
(1 Zeile)



Btw.: please no TOFU, read http://en.wikipedia.org/wiki/TOFU


Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===