Convert date field getdate() to "July 29" only

• hans.johnson

  Mr or Mrs. 500

  Points: 556

  More actions

  July 29, 2010 at 3:26 pm

  #227353

  I simply need to turn a date field into the full month name and the day of the month only. No year. So, if we were using getdate() for this if I just did this:

  select getdate()

  I would get this returned; 2010-07-29 17:25:13.110

  However, I need to convert that to this only; "July 29"

  How can I do this?

  select convert(varchar,convert(datetime,getdate()),100) gets me close withi Jul 29 2010 5:25PM but that's not what I need. Can anyone please help?

  Thanks for looking!

• andrewd.smith

  SSCrazy Eights

  Points: 8444

  More actions

  July 29, 2010 at 4:56 pm

  #1200081

  Try:

  SELECT DATENAME(month, GETDATE()) + ' ' + DATENAME(day, GETDATE())

  This also works in different languages:

  SET LANGUAGE N'e???????' /* Greek */

  SELECT DATENAME(month, GETDATE()) + ' ' + DATENAME(day, GETDATE())

• hans.johnson

  Mr or Mrs. 500

  Points: 556

  More actions

  July 30, 2010 at 8:10 am

  #1200354

  Thanks so much! That definitely gets me what I need.