Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

LAST_DAY(x)

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