Monday, January 1, 2024

Date Format in ifs

 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

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...