SQL Date Format Conversion
In SQL, the display of smalldatetime and datetime data is not so satisfactory, so I found some formatting methods to list them"
Convert (char (10), datetime, 101)
Converts data when the database is retrieved.
Select getdate ()
2006-05-12 11:06:08. 177
I sorted out the date format conversion methods that may be frequently used in SQL Server:
Example:
Select Convert (varchar (10), getdate (), 120)
2006-05-12
Select CONVERT (varchar, getdate (), 120)
2006-05-12 11:06:08
Select replace (CONVERT (varchar, getdate (), 120 ),'-',''),'',''),':','')
20060512110608
Select CONVERT (varchar (12), getdate (), 111)
2006/05/12
Select CONVERT (varchar (12), getdate (), 112)
20060512
Select CONVERT (varchar (12), getdate (), 102)
2006.05.12
Other uncommon date format conversion methods:
Select CONVERT (varchar (12), getdate (), 101)
0612/2005 select CONVERT (varchar (12), getdate (), 103)
12/09/2004
Select CONVERT (varchar (12), getdate (), 104)
12.05.2006
Select CONVERT (varchar (12), getdate (), 105)
12-05-
Select CONVERT (varchar (12), getdate (), 106)
12 05 2006
Select CONVERT (varchar (12), getdate (), 107)
05 12,200 6
Select CONVERT (varchar (12), getdate (), 108)
11:06:08
Select CONVERT (varchar (12), getdate (), 109)
0512 2006 1
Select CONVERT (varchar (12), getdate (), 110)
09-12-2004
Select CONVERT (varchar (12), getdate (), 113)
12 052006
Select CONVERT (varchar (12), getdate (), 114)
11:06:08. 177