How to convert date format to common string format by SQL
SQL how to convert the date format into a commonly used string format, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can get something.
SQL
Convert date format to common string format
There is a very powerful date formatting function
Select CONVERT (varchar (100), GETDATE (), 0): 05 16 2006 10:57AM
Select CONVERT (varchar (100), GETDATE (), 1): 05ax 16max 06
Select CONVERT (varchar, GETDATE (), 2): 06.05.16
Select CONVERT (varchar, GETDATE (), 3): 16-05-06
Select CONVERT (varchar, GETDATE (), 4): 16.05.06
Select CONVERT (varchar, GETDATE (), 5): 16-05-06
Select CONVERT (varchar (100), GETDATE (), 6): 16 05 06
Select CONVERT (varchar (100), GETDATE (), 7): 05 1606
Select CONVERT (varchar, GETDATE (), 8): 10:57:46
Select CONVERT (varchar), GETDATE (), 9): 05 16 2006 10:57:46:827AM
Select CONVERT (varchar, GETDATE (), 10): 05-16-06
Select CONVERT (varchar (100), GETDATE (), 11): 06Universe 16
Select CONVERT (varchar, GETDATE (), 12): 060516
Select CONVERT (varchar (100), GETDATE (), 13): 16 05 2006 10 purl 57 46 purl 937
Select CONVERT (varchar (100), GETDATE (), 14): 1015 57 GETDATE 46 7 7
Select CONVERT (varchar, GETDATE (), 20): 2006-05-16 10:57:47
Select CONVERT (varchar (100), GETDATE (), 21): 2006-05-16 10 GETDATE 47.157
Select CONVERT (varchar (100), GETDATE (), 22): 05x16 Select CONVERT 06 10:57:47 AM
Select CONVERT (varchar, GETDATE (), 23): 2006-05-16
Select CONVERT (varchar, GETDATE (), 24): 10:57:47
Select CONVERT (varchar (100), GETDATE (), 25): 2006-05-16 10 Suzhou 47.250
Select CONVERT (varchar (100), GETDATE (), 100): 05 16 2006 10:57AM
Select CONVERT (varchar (100), GETDATE (), 101): 05max 16Univer 2006
Select CONVERT (varchar (100,102): 2006.05.16)
Select CONVERT (varchar (100), GETDATE (), 103): 16Universe 2006
Select CONVERT (varchar (100,104) GETDATE (): 16.05.2006
Select CONVERT (varchar (100,105), GETDATE (): 16-05-2006
Select CONVERT (varchar (100,106) GETDATE (): 16 05 2006
Select CONVERT (varchar (100,107), GETDATE (): 05 16, 2006
Select CONVERT (varchar), GETDATE (), 10:57:49
Select CONVERT (varchar, GETDATE (), 109): 05 16 2006 10:57:49:437AM
Select CONVERT (varchar (100,110) GETDATE (): 05-16-2006
Select CONVERT (varchar (100,111), GETDATE (): 2006-05-16
Select CONVERT (varchar (100,112) GETDATE (): 20060516
Select CONVERT (varchar (100), GETDATE (), 113): 16 05 2006 10 GETDATE 57 49 15
Select CONVERT (varchar (100), GETDATE (), 11414): 1015, 57, 49
Select CONVERT (varchar, GETDATE): 2006-05-16 10:57:49
Select CONVERT (varchar (100), GETDATE (), 121,121): 2006-05-16 10 GETDATE 49.700
Select CONVERT (varchar (100,126): 2006-05-16T10:57:49.827
Select CONVERT (varchar (100,130): 18? 1427 10:57:49:907AM
Select CONVERT (varchar (100), GETDATE (), 131): 18Universe 1427 10:57:49:920AM
Commonly used:
Select CONVERT (varchar, GETDATE (), 8): 10:57:46
Select CONVERT (varchar, GETDATE (), 24): 10:57:47
Select CONVERT (varchar), GETDATE (), 10:57:49
Select CONVERT (varchar, GETDATE (), 12): 060516
Select CONVERT (varchar, GETDATE (), 23): 2006-05-16
Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.
