1. In Oracle
1 |
select last_day('1-feb-2014') from dual; |
1 |
select to_char(last_day('1-feb-2014'),'dd') from dual; |
2. In MySQL
1 |
select last_day('2014-02-1'); |
1 2 3 4 5 |
+-----------------------+ | last_day('2014-02-1') | +-----------------------+ | 2014-02-28 | +-----------------------+ |
1 |
select date_format(last_day('2014-02-1'), '%d'); |
1 2 3 4 5 |
+------------------------------------------+ | date_format(last_day('2014-02-1'), '%d') | +------------------------------------------+ | 28 | +------------------------------------------+ |