SELECT CONVERT(char(10), GetDate(), 111) --2013/01/15
Select Convert(VarChar, GetDate(), 101)
SELECT REPLACE(convert(varchar, getdate(), 102),'.','/') --2013/01/15
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)