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

How to use the CONVERT function in SQLServer? for this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

The code is as follows:

SELECT CONVERT (varchar), GETDATE (), 0): 05 16 2006 10:57AM SELECT CONVERT (varchar (100), GETDATE (), 1): 05 varchar 16 SELECT CONVERT (varchar), GETDATE (), 2): 06.05.16 SELECT CONVERT (varchar, GETDATE (), 3): 16-05-06 SELECT CONVERT (varchar (100), GETDATE (), 4): 16.05.06 SELECT CONVERT (varchar (100), GETDATE (), 5): 16-05-06 SELECT CONVERT (varchar GETDATE (), 6): 16 05 06 SELECT CONVERT (varchar, GETDATE (), 7): 05 16,06 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, GETDATE (), 11): 06GETDATE (varchar), GETDATE () 12): 060516 SELECT CONVERT (varchar, GETDATE (), 13): 16 05 2006 10 GETDATE (), 14): 10 varchar (100), GETDATE (), 14): 10 SELECT CONVERT 57 46 SELECT CONVERT (varchar), GETDATE (), 20): 2006-05-16 10:57:47 SELECT CONVERT (varchar, GETDATE (), 21): 2006-05-16 10 57 SELECT CONVERT (varchar), GETDATE () 22): 05 AM SELECT CONVERT 16 06 10:57:47 AM SELECT CONVERT (varchar), GETDATE (), 23): 2006-05-16 SELECT CONVERT (varchar), GETDATE (), 24): 10:57:47 SELECT CONVERT (varchar, GETDATE (), 25): 2006-05-16 1057 GETDATE 47.25 SELECT CONVERT (varchar, GETDATE, 100): 05 16 2006 10:57AM SELECT CONVERT (varchar, GETDATE): 0516 SELECT CONVERT GETDATE (): 2006.05.16 SELECT CONVERT (varchar, GETDATE (), 1010): 16.05.2006 SELECT CONVERT (varchar, GETDATE (), 2006): 16-05-2006 SELECT CONVERT (varchar, GETDATE): 1605 2006 SELECT CONVERT (varchar, GETDATE (), 107): 05 16,2006 SELECT CONVERT (varchar (100), GETDATE () 10:57:49 SELECT CONVERT (varchar, GETDATE): 0516 2006 10:57:49:437AM SELECT CONVERT (varchar, GETDATE): 05-16-2006 SELECT CONVERT (varchar, GETDATE): 2006-05-16 SELECT CONVERT (varchar, GETDATE): 20060516 SELECT CONVERT (varchar, GETDATE,): 16 05 2006 1015 10:57:49:437AM SELECT CONVERT (varchar), GETDATE () Varchar: 2006-05-16 10:57:49 SELECT CONVERT (varchar, GETDATE, 121l): 2006-05-16 10 GETDATE 5749 SELECT CONVERT 513 SELECT CONVERT (varchar, GETDATE, 126126): 2006-05-16T10:57:49.827 SELECT CONVERT (varchar, GETDATE (), 130): 18? 1427 10:57:49:907AM SELECT CONVERT (varchar GETDATE (), 131C: 18gamma 04gamble 1427 10:57:49:920AM

This is the answer to the question about how to use the CONVERT function in SQLServer. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.