A better way to get Day and Month(full name) from a date

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  August 8, 2007 at 12:26 am

  #119958

  Hi All,

  I am currently trying to get a the day and month from a date in the following format.

  07 July

  30 December

  Etc.

  I am currently doing this by storing the dates in a table and then using the DatePart function to find the month then getting the month from my table.

  I was simply wondering if anyone had come across a better method of doing this.

  Thanks

  Chris

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life

• James Moore (Red Gate)

  SSCrazy

  Points: 2644

  More actions

  August 8, 2007 at 2:39 am

  #725378

  Does DATENAME do what you want? http://msdn2.microsoft.com/en-us/library/ms174395.aspx

   

  James

  --
  James Moore
  Red Gate Software Ltd

• Christopher Stobbs

  SSC-Insane

  Points: 21098

  More actions

  August 8, 2007 at 3:51 am

  #725385

  Thanks that is 100% perfect.

  I should haev done more research before posting sorry

  ----------------------------------------------
  Try to learn something about everything and everything about something. - Thomas Henry Huxley

  :w00t:
  Posting Best Practices[/url]
  Numbers / Tally Tables[/url]

  SQL-4-Life

• James Moore (Red Gate)

  SSCrazy

  Points: 2644

  More actions

  August 8, 2007 at 4:05 am

  #725386

  No problem, always happy to help,

   

  James

  --
  James Moore
  Red Gate Software Ltd