timelyxyz

摘要： pgSql 语法 to_number(text, text) 例子 select to_number(trim(both 'ibs' from classname), '999999') as cn from bbs order by cn /*trim(both 'ibs' from classname)去除classname字段中的'ibs'字符*/mySql语法 str*1 / str+1 / -str /*str为varchar的数字，此处不一定是1，只要是数字即可*/ hql 语法 to_number(text, tex 阅读全文