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

It is believed that many inexperienced people have no idea about how to get the system time in sql server. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

A very powerful date formatting function in Sql Server: get the current system time GETDATE (): Tuesday, January 8, 2008, 14:59 Select CONVERT (varchar, GETDATE (), 0): 05 16 2008 10:57AM Select CONVERT (varchar, GETDATE (), 1): 05 GETDATE 1608 Select CONVERT (varchar, GETDATE (), 2): 08.05.16 Select CONVERT (varchar, GETDATE (), 3): 16-05-08 Select CONVERT (varchar (100), GETDATE (), 4): 16.05.08 Select CONVERT (varchar (100), GETDATE () 5): 16-05-08 Select CONVERT (varchar, GETDATE (), 6): 16 05 08 Select CONVERT (varchar (100), GETDATE (), 7): 05 16,08 Select CONVERT (varchar (100), GETDATE (), 8): 10:57:46 Select CONVERT (varchar (100), GETDATE (), 9): 05 16 2008 10:57:46:827AM Select CONVERT (varchar, GETDATE (), 10): 05-16-08 Select CONVERT (varchar (100), GETDATE () GETDATE (), 12): 080516 Select CONVERT (varchar), GETDATE (), 13): 16 05 2008 10 GETDATE 5746 Select CONVERT Select CONVERT (varchar, GETDATE (), 14): 1057 GETDATE 46 Select CONVERT (varchar, GETDATE (), 20): 2008-05-16 10:57:47 Select CONVERT (varchar (100), GETDATE (), 21): 2008-05-16 1057 Select CONVERT (varchar (100)) GETDATE (), 22): 05GETDATE 16 AM Select CONVERT 08 10:57:47 AM Select CONVERT (varchar, GETDATE (), 23): 2008-05-16 Select CONVERT (varchar, GETDATE (), 24): 10:57:47 Select CONVERT (varchar (100), GETDATE (), 25): 2008-05-16 10 Select CONVERT 57V 47.250 Select CONVERT (varchar (100), GETDATE (), 100): 05 16 2008 10:57AM Select CONVERT (varchar (100), GETDATE () Select CONVERT (varchar, GETDATE): 2008.05.16 Select CONVERT (varchar, GETDATE): 16,05Select CONVERT (varchar, GETDATE, 2008): 16.05.2008 Select CONVERT (varchar, GETDATE, 105): 16-05-2008 Select CONVERT (varchar, GETDATE, 106): 16 05 2008 Select CONVERT (varchar, GETDATE): 16 05 2008 Select CONVERT: 10:57:49 Select CONVERT (varchar, GETDATE): 0516 2008 10:57:49:437AM Select CONVERT (varchar, GETDATE): 05-16-2008 Select CONVERT (varchar, GETDATE, 2008): 2008-05-16 Select CONVERT (varchar, GETDATE): 20080516 Select CONVERT (varchar, GETDATE) 2008-05-16 10:57:49 Select CONVERT (varchar), GETDATE (), 2008-05-16 10:57:49 Select CONVERT (varchar, GETDATE,): 2008-05-16 10 GETDATE (): 49.700 Select CONVERT (varchar), GETDATE (): 2008-05-16T10:57:49.827 Select CONVERT (varchar), GETDATE () 1427 10:57:49:907AM Select CONVERT (varchar (100), GETDATE (), 131l): 18max 04max 1427 10:57:49:920AM

After reading the above, have you mastered the method of how to obtain the system time in sql server? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.