SQL中的字符串函数（国外英文资料）.doc

SQL中的字符串函数（国外英文资料） String functions LEN () : calculate the length of the string LOWER (), UPPER () : LOWER case, uppercase LTRIM () : the whitespace on the left of the string is removed RTRIM () : the whitespace on the right of the string is removed RTRIM ( bb ) LEFT (), RIGHT () intercepts the string The SUBSTRING (string, start_position and length) The parameter string is the main string, and the start_position is the initial location of the substring in the main string, and the length is the maximum length of the substring. SELECT SUBSTRING ( abcdef111 , 2, 3) Date function GETDATE () : get the current date time DATEADD (datepart, number, date) to calculate the date after the increase. The date that the parameter date is to be calculated; Parameter number is increment; The parameter datepart is a unit of measurement, and the optional value is shown in the note. DATEADD (DAY, 3, date) is the date of the date of date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date, date DATEDIFF (datepart, startdate, enddate) : calculates the difference between two dates. The datepart is a unit of measurement, which can be used for reference DateAdd. Count the number of students in different enrollment years: select DateDiff (year, sInDate, getdate ()) Count (*) from student Group by DateDiff (year, sInDate, getdate ()) DATEPART (DATEPART, date) : returns a specific part of a date The number of birthday years for students: select DatePart (year, sBirthday), count (*) The from student Group by DatePart (year, sBirthday) Type conversion function CAST AS data_type CONVERT (data_type, expression) Select your class number + 1 error. + is a math operator The SELECT FIdNumber, CAST (sNo, 3) AS INTEGER) AS the following three INTEGER forms, CAST (RIGHT (sNo, 3) AS INTEGER) + 1 AS 3 + 1, CONVERT (INTE