select month from last year sql code example Example: get current month last date in sql server SELECT EOMONTH('2019-02-15') end_of_month_feb2019;