Re: Date Problem

Ramesh PAtel wrote:

>Hi All
>
>now Problem is
>
>I have to date  From = '2003-04-01' and To='2003-05-12'
>now i want to use  use date butween  From and To.
>and each date one bye one use in query. so how to
>
>i  increse date one bye one
>
>Please Help me.
>
>Ramesh Patel
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>
>
You may do this :

 SELECT DATE (DATE '2003-04-01' + INTERVAL '24:00:00');


or build a PL/PGSQL function as this :

 CREATE FUNCTION onedaymore(DATE) RETURNS DATE AS '
   DECLARE
   olddate ALIAS FOR $1;
   newdate date;
   BEGIN
     newdate :=  olddate + INTERVAL ''24:00:00'';
     RETURN
newdate;
   END;
 '  LANGUAGE 'plpgsql';


--
Jean-Michel Chabanne
77450 MONTRY (FRANCE)
48" 54' N - 2" 49' E
Powered by Linux