Getting MonthAndYear name in sql?

Question

I need a small script to get the current month name and current year. So as to create a unique batch to store statements. My preferred format is January2011 or Feb2011 whichever is easier to get. i.e. MonthYear

score 3 · Accepted Answer · answered Apr 12 '11 at 11:32

3

Try a query that looks like this:

SELECT DATENAME(month, GETDATE()), DATENAME(year, GETDATE());

You can find some more information over here.

answered Apr 12 '11 at 11:32

Brecht

107
7

This would match the preferred format: SELECT DATENAME(month,GETDATE()) + DATENAME(year, GETDATE()) – Dubs Apr 12 '11 at 13:14

score 0 · Answer 2 · edited May 23 '17 at 10:33

0

Have a look at the DATEPART function and combine that with finding the name of a month, this SO question/answer has information on doing that.

edited May 23 '17 at 10:33

Community

1
1

answered Apr 12 '11 at 11:30

Tony

9,672
3
47
75

JStead · Answer 3 · 2011-04-12T11:47:36.820

0

You can use the following:

select datename(month,getdate()) + cast(datepart(year,getdate()) as char(4))

edited Apr 12 '11 at 11:47

answered Apr 12 '11 at 11:31

JStead

1,710
11
12

You are missing a closing bracket before the `as char(4)` – Tony Apr 12 '11 at 11:35

Getting MonthAndYear name in sql?

3 Answers3