Re: Problem with date calculation
От | Patrick FICHE |
---|---|
Тема | Re: Problem with date calculation |
Дата | |
Msg-id | 85058ADF852DD5118FD50002A528A5B6079A15@SERVEUR обсуждение исходный текст |
Ответ на | Problem with date calculation (Patrick FICHE <Patrick.FICHE@AQSACOM.COM>) |
Список | pgsql-general |
Thanks a lot, it worked... -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Stephan Szabo Sent: Monday, August 26, 2002 5:37 PM To: Patrick FICHE Cc: PostgreSQL - General (E-mail) Subject: Re: [GENERAL] Problem with date calculation On Mon, 26 Aug 2002, Patrick FICHE wrote: > Hi, > > I'm a newbie to Postgresql and have a problem manipulating dates in a > function... > > In fact, I want a function to add some days to the current date and return > the result date. > > My code would be something like : > > _DTcurrent := NOW() + interval ''_INTdays days''; I think, _DTcurrent := NOW() + CAST( _INTdays || '' days'' as interval); will work. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
В списке pgsql-general по дате отправления: