• Select Day(EOMONTH('2016-06-11 15:13:04.497')) AS NoOfDays

    NoOfDays

    -----------

    30

    select day('2016-06-11 15:13:04.497') as daystillnow

    daystillnow

    -----------

    11