SQL Query to select only Year and Month in SQL Server

Last Reply one year ago By mukesh1

Posted one year ago

i have date 2018-05-01 in database, but using sql select query i want to show only 2018-05, How to do this.

Posted one year ago Modified on one year ago

 

Convert(varchar(7),month_year,120) as Year_Month