SQL日期格式转换（SQL date format conversion）.docVIP

SQL日期格式转换（SQL date format conversion） SqlServer date (convert function, getdate function) The return value of the function GETDATE () is displayed only to seconds when it is displayed. In fact, the SQL Sever internal time can be accurate to milliseconds (exactly, it can be accurate to 3.33 MS). Type 0, 9, and 13 always return four bit years. For other types, show the century and add the style value to 100. Types 13 and 14 return 24 hours of clock time. Type 0, 7, and 13 return months are represented by three bit characters (represented by Nov for November) For each of the formats listed in table 11.1, you can add type values to 100 to show the century of the year (for example, the 00 year will be shown as 2000). For example, to display dates by Japanese standards, including the 20th century, you should use the following statement: SELECT, CONVERT (VARCHAR (30), GETDATE (), 111) In this example, the function CONVERT () converts the date format to 1997/11/30 To get dates and times in different formats, you need to use the function CONVERT (). For example, when the following statement is executed, the display time will include milliseconds: SELECT, CONVERT (VARCHAR (30), GETDATE (), 9) Notice the use of number 9 in the example. This number indicates which date and time format to use when displaying the date and time. When this statement is executed, the following date and time are displayed: Simplified Chinese OS:02 62007 4:33:56:530PM English OS:Nov 301997 3:29:55:170AM The style parameter in the convert function provides a variety of date display formats for converting datetime or smalldatetime to char or varchar. The numeric parameters of Style determine how the date is displayed. The year can be shown as two digits (YY) and can be shown as 4 digits (yyyy). For example, the style property to 100, you can get a 4 of the year, including century value (yyyy). The following table lists the available values of the style parameter and the various date formats that can be