Re: Date Problem

Поиск
Список
Период
Сортировка
От Jean-Michel Chabanne
Тема Re: Date Problem
Дата
Msg-id 3EB0D43A.8070407@free.fr
обсуждение исходный текст
Ответ на Date Problem  ("Ramesh PAtel " <ramesh@banas.guj.nic.in>)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Hargobind Singh"
Дата:
Сообщение: Re: Date Problem
Следующее
От: "Ramesh PAtel "
Дата:
Сообщение: Problem in FOR loop