v_new_date := round(v_old_date);
It works for dates as well as numbers.