数据库结构入下
id newsdate name
1 2005-7-3 aa
2 2006-7-3 bb
3 2008-7-3 cc
想实现,比如在7月3号这天,显示出我数据库里newsdate这个字段里的所有7月3号的信息,不管是哪天的,请问怎么实现啊
id newsdate name
1 2005-7-3 aa
2 2006-7-3 bb
3 2008-7-3 cc
想实现,比如在7月3号这天,显示出我数据库里newsdate这个字段里的所有7月3号的信息,不管是哪天的,请问怎么实现啊
from tablename
where dapart(mm,newsdate) = 7 and datepart(d,newsdate) = 3
id newsdate name
1 2005-7-3 aa
2 2006-7-3 bb
3 2008-7-3 cc
想实现,比如在7月3号这天,显示出我数据库里newsdate这个字段里的所有7月3号的信息,不管是哪天的,请问怎么实现啊select * from tb where month(newsdate) = 7 and day(newsdate) = 3
from table
where extract (month from newsdate) = 7 and extract (day from newsdate) = 3;
select *
from tablename
where month(newsdate) = month(getdate()) and datepart(day,newsdate) = datepart(day,getdate())
insert into tb values(1, '2005-7-3', 'aa')
insert into tb values(2, '2006-7-3', 'bb')
insert into tb values(3, '2008-7-3', 'cc')
go--方法一
select * from tb where month(newsdate) = 7 and day(newsdate) = 3
/*
id newsdate name
----------- ----------------------- ----------
1 2005-07-03 00:00:00.000 aa
2 2006-07-03 00:00:00.000 bb
3 2008-07-03 00:00:00.000 cc(3 行受影响)
*/--方法二
select * from tb where datepart(mm,newsdate) = 7 and datepart(day,newsdate) = 3
/*
id newsdate name
----------- ----------------------- ----------
1 2005-07-03 00:00:00.000 aa
2 2006-07-03 00:00:00.000 bb
3 2008-07-03 00:00:00.000 cc(3 行受影响)
*/
drop table tb
create procedure test @date as datetime
as
select * from tb
where newsdate = @dateexec test '2005-7-3'