DECLARE
a_ VARCHAR2(32000) := NULL;
default_date_ DATE := TO_DATE('&FROM_DATE', 'YYYY-MM-DD-HH24-MI-SS'); -- Assuming &FROM_DATE is a date
extracted_dd VARCHAR2(2) := TO_NUMBER(TO_CHAR(default_date_, 'DD'));
BEGIN
dbms_output.put_line(extracted_dd);
END;
No comments:
Post a Comment