SQL Date Time format conversion Daquan

Summary: We often use SQL date conversion, which lists all the code with date output as a string

Output Format 2014-06-12

Select CONVERT (varchar), GETDATE (), 23)  

Output format 2014-06-12 22:31:18

The following are the various conversion date code numbers:

------------------------------------------------------------------

Select CONVERT (varchar), GETDATE (), 0): 2006 10:57amselect CONVERT (varchar), GETDATE (), 1): 05/16/06select C Onvert (varchar), GETDATE (), 2): 06.05.16Select convert (varchar), GETDATE (), 3): 16/05/06select CONVERT (varchar (+), GETDATE (), 4): 16.05.06Select convert (varchar), GETDATE (), 5): 16-05-06select convert (varchar), GETDATE ( ), 6): 06Select CONVERT (varchar (+), GETDATE (), 7): 06Select convert (varchar), GETDATE (8): 10:57:46se Lect CONVERT (varchar), GETDATE (), 9): 2006 10:57:46:827amselect CONVERT (varchar), GETDATE (), 05-16-06s Elect convert (varchar), GETDATE (), each): 06/05/16select convert (varchar), GETDATE (), 060516Select convert ( varchar (+), GETDATE (), (+): 2006 10:57:46:937select CONVERT (varchar), GETDATE (), (+): 10:57:46:967select CONV ERT (varchar), GETDATE (), 2006-05-16 10:57:47select CONVERT (varchar), GETDATE (), 21): 2006-05-16 10:57:47.157select CONVERT (varchar), GETDATE (): 05/16/06 10:57:47 amselect CONVERT (varchar), GETDATE (), max): 2006-05-16select CONVERT (varchar), GETDATE () : 10:57:47select CONVERT (varchar), GETDATE (), (+): 2006-05-16 10:57:47.250select convert (varchar), GETDATE (), (+): 2006 10:57amselect CONVERT (varchar (+), GETDATE (), 101): 05/16/2006select CONVERT (varchar), GETDATE ( ), 102): 2006.05.16Select CONVERT (varchar (104), GETDATE (), 103): 16/05/2006select convert (varchar), GETDATE (),) : 16.05.2006Select CONVERT (varchar), GETDATE (), max.: 16-05-2006select convert (varchar), GETDATE (), 106): 16 05 2 006Select CONVERT (varchar), GETDATE (), 107): 2006Select convert (varchar, GETDATE (), 108): 10:57:49select CONVERT (varchar), GETDATE (), 109): 2006 10:57:49:437amselect CONVERT (varchar), GETDATE (), 110): 05-16-2006select CONVERT (varchar), GETDATE (), 111): 2006/05/16select CONVERT (varchar), GETDATE (), 112): 20060516Select CONVERT (varchar), GETDATE (), 113): 162006 10:57:49:513select CONVERT (varchar), GETDATE (), (): 10:57:49:547select convert (varchar), GETDATE (), : 2006-05-16 10:57:49select CONVERT (varchar (+), GETDATE (), 121): 2006-05-16 10:57:49.700select convert (varchar ( (+), GETDATE (), 126): 2006-05-16t10:57:49.827select CONVERT (varchar), GETDATE (), ():???? ??????  1427 10:57:49:907amselect CONVERT (varchar (+), GETDATE (), 131): 18/04/1427 10:57:49:920am

If you think reading this blog gives you something to gain, you might want to click " recommend " in the lower right corner.

If you want to find my new blog more easily, click on " Follow me "

If you want to give me more encouragement, you may wish to click on the right, " enjoy your stay"

Blog is his own summary of the results of learning, learning to summarize the knowledge-"analysis of the problem-" to solve the problem.

Where the views/descriptions in the text are incorrect, please correct them.

Thank you for your reading, if you are interested in the content of my blog, please continue to follow my following blog, I am yxtic.

SQL Date Time format conversion Daquan