select ID=identity(int, 0, 1),* into aaaaa from aaaa
update aaaaa set col7=dateadd(second, ID*10, col7),col8=dateadd(second, ID*10, col8)我用了这两句话自动每行增加10秒,能不能加个语句限定在晚上21:00:00到早上9:00:00这段时间不在这个增加的范围内呢?
update aaaaa set col7=dateadd(second, ID*10, col7),col8=dateadd(second, ID*10, col8)我用了这两句话自动每行增加10秒,能不能加个语句限定在晚上21:00:00到早上9:00:00这段时间不在这个增加的范围内呢?
or convert(varchar, col7, 108) <= 09:00:00
where convert(varchar, col7, 108) between 09:00:00 and 21:00:00
或者
where convert(varchar, col7, 108) > 09:00:00
and convert(varchar, col7, 108) < 21:00:00
set col7=dateadd(second, ID*10, col7),col8=dateadd(second, ID*10, col8)
where convert(varchar, col7, 108) not between '21:00:00' and '09:00:00'
and
convert(varchar, col8, 108) not between '21:00:00' and '09:00:00'
1 0 2007-1-31 17:09 2007-1-31 18:01
1 0 2007-1-31 17:09 2007-1-31 18:01
1 0 2007-1-31 17:09 2007-1-31 18:01
我的表是这样的`有好几十万`是DATETIME类型的`现在是17:09`第一行加10秒`但是加到晚上21:00时就不加了`直接跳到早上9:00这个时候再继续累加`这样行吗?
update aaaaa set col7=dateadd(second, ID*10, col7)
where convert(varchar(10),co17,108) < '09:00:00' or convert(varchar(10),co17,108) > '21:00:00'
update aaaaa set col8=dateadd(second, ID*10, col8)
where convert(varchar(10),co18,108) < '09:00:00' or convert(varchar(10),co18,108) > '21:00:00'
1 0 2007-1-31 17:09 2007-1-31 18:01
1 0 2007-1-31 17:09 2007-1-31 18:01
1 0 2007-1-31 17:09 2007-1-31 18:01
1 0 2007-1-31 17:09 2007-1-31 18:01
我的表是这样的`有好几十万`是DATETIME类型的`现在是17:09`第一行加10秒`但是加到晚上21:00时就不加了`直接跳到早上9:00这个时候再继续累加`这样行吗?
1 0 2007-1-31 17:00 2007-1-31 18:00
1 0 2007-1-31 17:00 2007-1-31 18:00
1 0 2007-1-31 17:00 2007-1-31 18:00
1 0 2007-1-31 17:00 2007-1-31 18:00我的表是这样四列的`有好几十万`后两列是DATETIME类型的`现在是17:00``每一行递加10秒`但是当计算加到晚上21:00时就不加了`直接跳到早上9:00这个时候再继续累加`这样行吗?