declare v_date date := sysdate; v_str_date varchar2(8); begin dbms_output.enable(100000); v_str_date := to_char(v_date,'YYYYMMDD'); dbms_output.put_line(v_str_date); end;