-
SQL code
-
CONVERT (nvarchar (10), count_time, 121): CONVERT is a date conversion function, generally in the time type (datetime, smalldatetime) and string type (nchar, nvarchar, char, varchar) the three parameters of the function used only during mutual conversion. The 1st parameters are the converted size, 2nd are the fields or functions of the conversion date, and the 3rd are the conversion format, details: 0 | 0 or 100 | mon dd yyyy hh: miAM (or PM) 1 | 101 | mm/dd/yy 2 | 102 | yy-mm-dd 3 | 103 | dd/mm/yy 4 | 104 | dd-mm-yy 5 | 105 | dd-mm-yy6 | 106 | dd mon yy7 | 107 | mon dd, yy8 | 108 | hh: mm: ss 9 | 9 or 109 | mon dd yyyy Hh: mi: ss: mmmmAM (or PM) 10 | 110 | mm-dd-yy11 | 111 | yy/mm/dd12 | 112 | yymmdd11 | 13 or 113 | dd mon yyyy hh: mi: ss: mmm (in 24-hour format) 14 | 114 | hh: mi: ss: mmm (in 24-hour format) 15 | 20 or 120 | yyyy-mm-dd hh: mi: ss (in 24-hour format) 16 | 21 or 121 | yyyy-mm-dd hh: mi: ss: mmm (in 24-hour format) Example: select convert (varchar (100 ), GETDATE (), 0): 05 16 2006 10: 57 amselect convert (varchar (100), GETDATE (), 1): 05/16/06 select convert (varchar (100 ), GETDATE (), 2): 06.05.16SELECT CONVERT (varchar (100), GETDATE (), 3): 16/05/06 select convert (varchar (100), GETDATE (), 4 ): 16.05.06SELECT CONVERT (varchar (100), GETDATE (), 5): 16-05-06SELECT 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: 827 AMSEL Ect convert (varchar (100), GETDATE (), 10): 05-16-06SELECT 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): 2006-05-16 10: 57: 47 select convert (varchar (100), GETDATE (), 21): 2006-05-16 1 0:57:47. 157 select convert (varchar (100), GETDATE (), 22): 05/16/06 10:57:47 amselect convert (varchar (100), GETDATE (), 23 ): 2006-05-16SELECT 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 10: 57 amselect convert (varchar (100), GETDATE (), 101 ): 05/16/2006 select convert (varchar (100 ), GETDATE (), 102): 2006.05.16SELECT CONVERT (varchar (100), GETDATE (), 103): 16/05/2006 select convert (varchar (100), GETDATE (), 104 ): 16.05.2006SELECT CONVERT (varchar (100), GETDATE (), 105): 16-05-2006SELECT 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: 437 amselect convert (varchar (100), GETDATE (), 110): 05-16-2006SELECT 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): 2006-05-16 10: 57: 49 SELECT C ONVERT (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: 907 amselect convert (varchar (100), GETDATE (), 131): 18/04/1427 10: 57: 49: 920AM
|
|