حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

SQL Query to select only Year and Month in SQL Server

mukesh1

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

mukesh1

0 1

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html