Quote:SELECT convert(varchar(12), getdate(), 106)
SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [DD Month YYYY]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)