Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

SELECT LAST_DAY(01-JAN-2005) FROM dual

SQL>  SELECT LAST_DAY('01-JAN-2005')  FROM dual; LAST_DAY( --------- 31-JAN-05