时间: 2021-08-13 作者:daque
149.atan2() 归来用弧度表白的观点的x和y坐目标归正切值. selectatan2(0.5,0.9)frombsempms; 150.bigint() 归来整型恒量中的数字或字符串的64位平头表白. selectbigint(emp_no)frombsempms; 151.ceiling()orceil() 归来比参数大或即是参数的最小的平头值. selectceiling(3.56)frombsempms; selectceil(4.67)frombsempms; 152.char() 归来日子功夫型,字符串,平头,十进制或双精度浮点数的字符串表白. selectchar(salary,',')frombsempms; 153.chr() 归来具备由参数指定的ascii码的字符. selectchar(167)frombsempms;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; 167.repeat(exp1,exp2) 归来exp1反复exp2次后的字符串. selectchar(repeat('repeat',3),21)frombsempms; 168.real() 归来一个数值的单精度浮点数表白. selectreal(10)frombsempms; 169.rand() 归来0和1之间的随机浮点数. selectrand()frombsempms; 170.power(exp1,exp2) 归来exp1的exp2次幂. selectpower(2,5)frombsempms; 171.posstr(exp1,exp2) 归来exp2在exp第11中学的场所. select('abcdefgh','d')frombsempms; 172.nullif(exp1,exp2) 即使exp1=exp2,则为null,要不为exp1173.nodenumber() 归来行的分区号. selectnodenumber(emp_no)frombsempms; 174.month() 归来一个数值的月局部. selectmonth('2003/10/20')frombsempms; 175.mod(exp1,exp2) 归来exp1除以exp2的余数. selectmod(20,8)frombsempms; 176.minute() 归来一个数值的秒钟局部. selectminute('18:34:23')frombsempms; 177.ltrim() 简略字符串前方的空格. selectltrim('cddd')frombsempms; 178.hour() 归来一个数值的钟点局部. selecthour('18:34:23')frombsempms; 179.double() 即使参数是一个数字表白式,归来与其对立应的浮点数,即使参数是字符串表白式,则归来该数的字符串表白式. selectdouble('5678')frombsempms; 180.exp() 归来参数的指数因变量. selectexp(2)frombsempms; 181.float() 归来一个数的浮点表白. selectfloat(789)frombsempms; 182.floor() 归来小于或即是参数的最大平头. selectfloor(88.93)frombsempms; 183.hex() 归来一个表白为字符串的值的16进制表白. selecthex(16)frombsempms;