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 ===