Here are some more date formats that does not come standard in SQL Server as
SELECT CONVERT(VARCHAR(25), SYSDATETIME(), 131) SELECT CONVERT(VARCHAR(26), SYSDATETIME(), 130) SELECT CONVERT(VARCHAR(27), SYSDATETIME(), 126) SELECT CONVERT(VARCHAR(26), SYSDATETIME(), 25) SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 24) SELECT CONVERT(VARCHAR(26), SYSDATETIME(), 23) SELECT CONVERT(VARCHAR(20), SYSDATETIME(), 22) SELECT CONVERT(VARCHAR(23), SYSDATETIME(), 121) SELECT CONVERT(VARCHAR(19), SYSDATETIME(), 120) SELECT CONVERT(VARCHAR(16), SYSDATETIME(), 114) AS SELECT CONVERT(VARCHAR(16), SYSDATETIME(), 14) AS SELECT CONVERT(VARCHAR(30), SYSDATETIME(), 113) SELECT CONVERT(VARCHAR(30), SYSDATETIME(), 13) SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 112) AS SELECT CONVERT(VARCHAR(6), SYSDATETIME(), 12) AS SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 111) AS SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 11) AS SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 110) AS SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 10) AS SELECT CONVERT(VARCHAR(26), SYSDATETIME(), 109) SELECT CONVERT(VARCHAR(26), SYSDATETIME(), 9) SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 108) SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 8) SELECT CONVERT(VARCHAR(12), SYSDATETIME(), 107) AS SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 7) AS SELECT CONVERT(VARCHAR(11), SYSDATETIME(), 106) AS SELECT CONVERT(VARCHAR(9), SYSDATETIME(), 6) AS SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 105) AS SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 5) AS
SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 104) AS SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 4) AS SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 103) AS SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 3) AS SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 102) AS
SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 2) AS SELECT CONVERT(VARCHAR(10), SYSDATETIME(), 101) AS SELECT CONVERT(VARCHAR(8), SYSDATETIME(), 1) AS SELECT CONVERT(VARCHAR(20), SYSDATETIME(), 100) To make the date format results consistent, the date and time used to generate the sample output is J1:30:45.9428675 PM. The results will be the same unless the date format includes the The SYSDATETIME()įunction used below can be replaced by the GETDATE() or GETUTCDATE() functions. SYSDATETIME() function returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The SQL statements used below to return the different date formats use the SYSDATETIME() date function, which is new to SQL Server 2008. Using the VARCHAR value of the date and time and not its original DATETIME With this in mind,Īny date comparisons performed after the datetime value has been formatted are Types already and not of DATETIME data type. It is worth to note that the output of these date formats are of VARCHAR data Following the standard date formats are some extended dateįormats that are often asked by SQL Server developers. The different date formats that come standard in SQL Server as part of the CONVERTįunction.
#CONVERT STRING TO DATE IN SQL SERVER 2008 EXAMPLE HOW TO#
One of the most frequently asked questions in SQL Server forums is how to format aĭatetime value or column into a specific date format. Home > SQL Server 2008 > SQL Server 2008 Date Formats
0 kommentar(er)
