Category: SQL

SQL

To Print the last day of the month in SQL

Posted on by

1. In Oracle

last day of February month
Oracle PL/SQL
1
select last_day('1-feb-2014') from dual;

last day of February month
1
select to_char(last_day('1-feb-2014'),'dd') from dual;

2. In MySQL

last day of February month in MySQL
MySQL
1
select last_day('2014-02-1');

1
2
3
4
5
+-----------------------+
| last_day('2014-02-1') |
+-----------------------+
| 2014-02-28            |
+-----------------------+

last day of February month in MySQL
MySQL
1
select date_format(last_day('2014-02-1'), '%d');

1
2
3
4
5
+------------------------------------------+
| date_format(last_day('2014-02-1'), '%d') |
+------------------------------------------+
| 28                                       |
+------------------------------------------+