创建一个表:
create table Material(
)
可以进行数据的操作,请看以下:
select * from Material ;
insert into Material (createTime) values(convert(varchar(10),getdate(),120));
1.年的查询
--查询某年
select
--查询某年到某年
select
2.月的查询
--查询某月
select *from
select
select * from Material where createTime between datename(year,getdate())+'-10-01' and datename(year,getdate())+'-10-30'
--查询某年某月
select * from Material where convert(varchar(7),createTime,120) between '2011-09' and '2011-10'
3.日的查询
--查询某日
select
--查询某年某月某日
select * from Material where createTime between '2011-10-1' and '2011-11-6'
select * from Material where createTime between datename(year,getdate())+'-10-1' and datename(year,getdate())+'-11-8'