时间: 2021-08-13 作者:daque
154.concat() 归来两个字符串的贯穿. selectconcat(emp_no,emp_nam)frombsempms; 155.year() 归来数值的年局部. selectyear('2003/01/02')frombsempms; 156.varchar() 归来字符串,日子型,图形串的可变长度的字符串表白. selectvarchar(emp_nam,50)frombsempms; 157.ucase()orupper() 归来字符串的小写. selectucase(emp_nam)frombsempms; selectupper(emp_no)frombsempms; 158.truncate()ortrunc() 从表白式少量点右边的场所发端截断并归来该数值. selecttruncate(345.6789,2)frombsempms; 159.time() 归来一个数值中的功夫. selecttime('2001-03-19.12.30.123456')frombsempms; 160.substr(exp1,exp2) 归来exp1串自exp2处发端的子串. selectsubstr('cdnjfdjfjd',5)frombsempms; selectsubstr('cdnjfdjfjd',5,2)frombsempms; 161.sqrt() 归来该参数的平方根. selectsqrt(36)frombsempms; 162.space() 归来由参数指定的长度,包括空格在前的字符串. selectspace(10)frombsempms; 163.second() 归来一个数值的秒局部. selectsecond('18:34:32')frombsempms; 164.rtrim() 简略字符串尾部的空格. selectrtrim('comment')frombsempms; 165.round(exp1,exp2) 归来exp1少量点右边的第exp2场所处发端的四舍五入值. selectround(2345.6789,2)frombsempms; 166.replace(exp1,exp2,exp3) 用exp3代替exp第11中学一切的exp2 selectchar(replace('romandd','ndd','ccb'),10)frombsempms;