1
Reply

Show Datetime into Month Name And year format in SQL

Ask a question
Pravin Ghadge

Pravin Ghadge

12y
2k
1
Hi,

I want to shpw the datetime value in to Month Name And year format

For Eg:

26/09//12    =>Sep 2012


I have tried foll query also:
LEFT(DATENAME(mm, '26/09//12  '), 3) + '-' + RIGHT(CAST(YEAR('26/09//12  ') AS VARCHAR), 2)

But it is not working .
Kindly help me..


Answers (1)