date in MMYY format

Question

Hi ,
Can any one tell me how to write date time in Month and Year format?
Ex;
01.01.09 00:00:00  should be Jan 2009

Thanks

---

shamen

Answer 1

Look at the DATEPART in BOL

Answer 2

 

declare @dt DATETIME

SET @dt='01.01.09 00:00:00'

SELECT STUFF(CONVERT(VARCHAR(12),@dt,107),4,4, ' ') as MMYY  --Jan  2009

Answer 3

 

SELECT RIGHT(CONVERT(VARCHAR(12),getdate(),106),8)

---

Mangal Pardeshi
SQL With Mangal
Technical Skill is the mastery of complexity, while Creativity is the master of simplicity

Answer 4

Hi shamen,

limno and Magal's answer is good.

But if you are not in the location "us_english", please add " SET LANGUAGE 'us_english' " at the begin of the statement.

Thanks,

Jin

---

Jin Chen - MSFT