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 по дате отправления: