SQL语句 如何删除指定日期段的记录

[johntl]

如何删除指定日期段的记录 如我要删除 tb表 2004年8月5日 至 2006年10月25日的记录 SQL语句怎么写

我是新手.还没分给. :(

[hui_hui_2007]

delete from tb where 日期字段>= '2004-8-5' and 日期字段 <'2006-10-26'
注意，红色的地方。

[hui_hui_2007]

当然，二楼的代码只适用于存放日期的字段是日期型。
如果是字符型，应要找规律了。

[fuda_1985]

[Quote=引用 1 楼 zhang_yugang 的回复:]
SQL codedelete from tb where columnname between '2004/8/5' and '2006/10/25'
[/Quote]

[iamltd]

直接用between不太稳当，建议用datediff

delete from tb where datediff(d,columnname,'2004-8-5') <= 0 and datediff(d,columnname,'2006-10-25') >= 0

[fengb4676]

delete from tb where convert(varchar(10), columnname, 120)>='2004-8-5' and convert(varchar(10), columnname,120)<='2006-10-25')

[zhang_yugang]

delete from tb where columnname between '2004/8/5' and '2006/10/25'

[zhang_yugang]

main()

[zhang_yugang]

split

[wynlc]

delete from tb where convert(varchar(13), columnname, 120)>='2004-8-5 22' and convert(varchar(13), columnname,120)<='2006-10-25 23')

[zhang_yugang]

[Quote=引用 5 楼 iamltd 的回复:]
直接用between不太稳当，建议用datediff

SQL codedeletefromtbwheredatediff(d,columnname,'2004-8-5')<=0anddatediff(d,columnname,'2006-10-25')>=0
[/Quote]
用这吧！

[JJkukow]

declare @dt1 datetime,@dt2 datetime
set @dt1='2005-01-01'
set @dt2='2008-01-01'
delete from table1 where convert(varchar(10),date,120) between @dt1 and @dt2

[johntl]

呵呵这里就是好.很多高手回复. 谢谢你们