SQL/ORACLE 小知识整理(不定时更新)
更改表中某一列值中的某个字符:
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