..::inget’s Sequel Roundup

select * from zu03txn
where u_dt <= to_char(to_date(‘01′ || ‘/’ || ‘04′ || ‘/’ || ‘2008′, ‘DD/MM/YYYY’))

inget2 :

CREATE OR REPLACE FUNCTION roundup(p_number IN NUMBER,
p_pos IN NUMBER DEFAULT 0) RETURN NUMBER IS
l_result NUMBER;
BEGIN
l_result := ROUND(p_number, p_pos);
IF (l_result < p_number) THEN — ROUNDED DOWN
l_result := l_result + (1/POWER(10,p_pos));
END IF;
RETURN l_result;
END;
/