Deepak M

Deepak M

  • 1.2k
  • 546
  • 36.7k

How to get month list in SQL Server?

Feb 6 2020 3:52 AM
Hello to all,
 
 
How to get all month list of a year by a given year with out using loop like below stracture.
MID   MNAME
1         Jan-20
2         Feb-20
3         Mar-20
4         Apr-20
5         May-20
6         Jun-20
7         Jul-20
8         Aug-20
9         Sep-20
10       Oct-20
11       Nov-20
12       Dec-20

Answers (2)