How to format date to mm/dd?

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  March 19, 2003 at 6:44 pm

  #105893

  What is the best way to format the current date to a 5 character string that consists of MM/DD where MM is the month number and DD for the day with leading zeros where required? (eg. March 4 would be 03/04)?

  Thanks in advance

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  March 19, 2003 at 8:38 pm

  #451520

  The date is stored internally in SQL Server in its own format. The client display depends on what is set on the client system.

  If you want to convert it you can use the CONVERT statement (see BOL)

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  March 19, 2003 at 8:42 pm

  #451522

  Select Convert(Char(5),GetDate(),101)

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  March 20, 2003 at 11:53 am

  #451609

  Thanks. "Select Convert(Char(5),GetDate(),101)" gives me exactly what I asked for.

  However, I used the wrong example to illustrate my question. What if I want "MM/YYYY"? Do I have to get fancy and do it like this?

  Select Convert(Char(2),GetDate(),101) &#43+ '/' &#43+ right(Convert(Char(10),GetDate(),101), 4)

  Thanks

  Billy

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  March 20, 2003 at 12:35 pm

  #451615

  Select substring(convert(char(10), GetDate(), 103), 4, 7)

  --

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  March 20, 2003 at 2:41 pm

  #451629

  Saving a cpu cycle

  Select Right(Convert(char(10),getdate(),103),7)