SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY] --OR-- SELECT CAST(DAY(GETDATE()) AS VARCHAR) +'/'+ CAST(MONTH(GETDATE()) AS VARCHAR) + '/' + CAST(YEAR(GETDATE()) AS VARCHAR) --LINK --http://www.sql-server-helper.com/tips/date-formats.aspx
SELECT CONVERT(nvarchar(30), GETDATE(), 103 ) AS dateINddmmyyyy
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)