Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

LAST_DAY

The LAST_DAY function retrieves the last day of the month in the specified date. v_dt:= LAST_DAY (date); SQL> SQL> declare   2      v_dt DATE;   3      v_form_tx  VARCHAR2(25):=   4                 'DD-MON-YYYY HH24:MI:SS';   5  begin   6      v_dt:=last_day(sysdate);   7      DBMS_OUTPUT.put_line(to_char(v_dt,v_form_tx));   8  end;   9  / 30-JUN-2007 20:32:45 PL/SQL procedure successfully completed. SQL>