Is there a better way to do this?
| От | Wei Weng |
|---|---|
| Тема | Is there a better way to do this? |
| Дата | |
| Msg-id | 46D48CC2.1080105@kencast.com обсуждение исходный текст |
| Ответы |
Re: Is there a better way to do this?
Re: Is there a better way to do this? Re: Is there a better way to do this? Re: Is there a better way to do this? Re: Is there a better way to do this? Re: Is there a better way to do this? |
| Список | pgsql-general |
Hi all
I want to implement something like the following:
CREATE OR REPLACE FUNCTION AddDays
(TIMESTAMP WITHOUT TIME ZONE
, INT)
RETURNS TIMESTAMP WITHOUT TIME ZONE AS '
DECLARE
time ALIAS FOR $1;
days ALIAS FOR $2;
BEGIN
RETURN time+days*24*3600*''1 second''::INTERVAL;
END;
' LANGUAGE 'plpgsql';
Basically the function takes two parameters, and add the second one (as
days) onto the first one (as timestamp without timezone)
I don't really like this implementation. Is there a more concise way to
do this?
Thanks
Wei
В списке pgsql-general по дате отправления: