date in sqlserver modification

Posted by Venkatesh under Sql Server on 4/27/2011 | Points: 10 | Views : 918 | Status : [Member] | Replies : 2
Hi

i have dates in a table like mm-dd-yyyy(04-01-2006)

now i want mm/dd/yyyy like (04/01/2006)

Thanks
Venkatesh.p




Responses

Posted by: Ndebata on: 4/27/2011 [Member] Starter | Points: 25

Up
0
Down
You can use convert function with type 101 , instead of getdate() , use the date you want to format
Select CONVERT(VARCHAR(10), GETDATE(), 101)

Venkatesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Venkatesh on: 4/27/2011 [Member] Starter | Points: 25

Up
0
Down
Thanks

Venkatesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response