Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.