'm/d/yyyy' date format?

Last Post 28 Jan 2005 03:11 PM by donnie100. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
donnie100
New Member
New Member

--
28 Jan 2005 12:02 PM
Hi everyone!

I have a date in the following format: 'mm/dd/yyyy' but I would like to change it to: 'm/d/yyyyy' for example: '06/30/2004'. I tried Convert function but couldn't find any deisred results.
Any ideas about how to change date format to 'm/d/yyyyy' will be greatly appreciated.

Thank you!
donnie100
New Member
New Member

--
28 Jan 2005 03:11 PM
Great. Thank you for your help!
solartouch
New Member
New Member

--
04 Feb 2005 06:33 PM
select convert(varchar(2), month(getdate())) + '/' + convert(varchar(2), day(getdate())) + '/' + convert(varchar(4), year(getdate()))
You are not authorized to post a reply.

Acceptable Use Policy