Question

DB2如何实现以时间字段为条件删除一段时间的记录

delete * from smsinfo where BETWEEN smsdate like '%2013-05-18%' and smsdate like '%2013-05-28%'
要删除18到28号的记录，哪位大神给指点下上面哪里错了？
昨天已将问题解决，不过还是非常感谢二位回答
delete from(select * from smsinfo where 1=1 and smsdate like '2013-05-16%'or smsdate like '2013-05-18%' )
日期字段data类型

Answer 1

你的日期类型是什么？ 你先db2 describe table smsinfo看下smsdat的字段类型

追问

data类型

Answer 2

delete * from smsinfo where date(smsdate)>='2013-05-18' and date(smsdate) <= '2013-05-28'