kikyo1990

摘要： 更改表中某一列值中的某个字符：update nwother_callpolice set imgrgb =replace(cast( imgrgb as varchar(50)) ,'，',',')nwother_callpolice：表imgrgb：列名将中文逗号“，”更正为“,”查询出时间列表中的 小时：分钟select distinct(to_char(t.forecasttime,'HH24:MI')) as timenew from nwbase_stationforecast t order by timenew asc 阅读全文