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,
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