On Dec 18, 2005, at 20:44 , stig erikson wrote:
> my problem is, how do i make postgresql understand that i want to
> add 2 days to the current time?
test=# select current_timestamp as "now"
, current_timestamp + 2 * interval '1 day' as "2 days from now";
now | 2 days from now
-------------------------------+-------------------------------
2005-12-21 14:31:58.338283+09 | 2005-12-23 14:31:58.338283+09
(1 row)
Michael Glaesemann
grzm myrealbox com