vvvlad blognote: Convert

Showing posts with label Convert. Show all posts

Tuesday, January 20, 2009

Converting Dates in SQL Server

     SELECT 

       GETDATE() AS DefaultFormat,

       CONVERT(nvarchar(30), GETDATE(), 101) AS US,

       CONVERT(nvarchar(30), GETDATE(), 103) AS UK,

       CONVERT(nvarchar(30), GETDATE(), 111) AS Japan,

       CONVERT(nvarchar(30), GETDATE(), 104) AS German,

       CONVERT(nvarchar(30), GETDATE(), 112) AS ISO,

       CONVERT(nvarchar(30), GETDATE(), 109) AS Date_with_Milliseconds

Source