select convert(varchar, convert(datetime, '13/06/2014', 103), 101)
SELECT CONVERT(VARCHAR,CONVERT(VARCHAR,GETDATE(),103),101)
SELECT CONVERT(VARCHAR,GETDATE(),103)
select convert(varchar,getdate(),103) --dd/mm/yyyy select convert(varchar,getdate(),101) --mm/dd/yyyy
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)