多谢!作者: css1978 时间: 2005-11-27 12:06
用一个中间表把间隔5分钟的数据查出来。一句好像还比较难写作者: sshd 时间: 2005-11-27 14:53
use "substr" to get the minute and "like" to make sure it ends end either 0 or 5.
in 10g use regexp_like作者: macrodba 时间: 2005-11-28 09:42
学习作者: ddmmdd 时间: 2005-11-28 10:57
delete from his_data where substr(to_char(occur_time,'mi'),2,1) not in ('0','5');
试试看。作者: lov 时间: 2005-11-28 22:23
多谢大家,我搞定了
DELETE FROM his_data WHERE occur_time NOT LIKE '%0:00' AND occur_time NOT LIKE '%5:00' ;