convert varchar to month year format in sql server or javascript

I have a ”varchar” like ‘2020-08’ in ”sql” table. I need to convert it like ‘Aug 2020’ to show it in my web page.

select convert(varchar,’2020-08′,107)

This does not seem to work.

Add Comment
1 Answer(s)

Ciao, why don’t convert data directly in web page using moment? Something like:

let data = '2020-08';  console.log(moment('2020-08').format("MMM YYYY"))
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.17.1/moment.min.js"></script>

Answered on August 30, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.