Number of Days in Current Month

This Query to get number of days in Specific month at Specific Year :

select to_number(to_char(last_day(to_date('01/02/2008','DD/Mm/yyyy')),'DD')) as days from dual

you have to replace date '01/02/2008' with the date you want or the date from sysdate

Thanks,

Comments

Popular posts from this blog

SQL Interview Questions

Manage Your Database Connection