Recently, the date and time format conversion was used to design the database table structure. After a long time, I had to worry about it for a long time. I found that I forgot a lot of things I learned before.
It seems that it is easy to forget that it is not commonly used. Repeat the SQL Server date and time format conversion string. In the SQL Server database,
The SQL Server date and time format conversion string can change the SQL Server date and time format, which should be mastered by each SQL database user.
Datetime to string:
- Select convert (varchar (100), getdate (), 0): 05 16 2006 AM
- Select convert (varchar (100), getdate (), 1): 05/16/06
- Select convert (varchar (100), getdate (), 2): 06.05.16
- Select convert (varchar (100), 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 (100), getdate (), 6): 16 05 06
- Select convert (varchar (100), getdate (), 7): 05 16, 06
- Select convert (varchar (100), getdate (), 8): 10:57:46
- Select convert (varchar (100), getdate (), 9): 05 16 2006 10: 57: 46: 827am
- Select convert (varchar (100), getdate (), 10): 05-16-06
- Select convert (varchar (100), getdate (), 11): 06/05/16
- Select convert (varchar (100), getdate (), 12): 060516
- Select convert (varchar (100), getdate (), 13): 16 05 2006 10: 57: 46: 937
- Select convert (varchar (100), getdate (), 14): 10: 57: 46: 967
- Select convert (varchar (100), getdate (), 20): 10:57:47
- Select convert (varchar (100), getdate (), 21): 10:57:47. 157
- Select convert (varchar (100), getdate (), 22): 05/16/06 10:57:47 AM
- Select convert (varchar (100), getdate (), 23 ):
- Select convert (varchar (100), getdate (), 24): 10:57:47
- Select convert (varchar (100), getdate (), 25): 10:57:47. 250
- Select convert (varchar (100), getdate (), 100): 05 16 2006 AM
- Select convert (varchar (100), getdate (), 101): 05/16/2006
- Select convert (varchar (100), getdate (), 102): 2006.05.16
- Select convert (varchar (100), getdate (), 103): 16/05/2006
- Select convert (varchar (100), getdate (), 104): 16.05.2006
- Select convert (varchar (100), getdate (), 105): 16-05-2006
- Select convert (varchar (100), getdate (), 106): 16 05 2006
- Select convert (varchar (100), getdate (), 107): 05 16,200 6
- Select convert (varchar (100), getdate (), 108): 10:57:49
- Select convert (varchar (100), getdate (), 109): 05 16 2006 10: 57: 49: 437am
- Select convert (varchar (100), getdate (), 110): 05-16-2006
- Select convert (varchar (100), getdate (), 111): 2006/05/16
- Select convert (varchar (100), getdate (), 112): 20060516
- Select convert (varchar (100), getdate (), 113): 16 05 2006 10: 57: 49: 513
- Select convert (varchar (100), getdate (), 114): 10: 57: 49: 547
- Select convert (varchar (100), getdate (), 120): 10:57:49
- Select convert (varchar (100), getdate (), 121): 10:57:49. 700
- Select convert (varchar (100), getdate (), 126): 2006-05-16t10: 57: 49.827
- Select convert (varchar (100), getdate (), 130): 18 ???? ?????? 1427 10: 57: 49: 907am