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