SQL数据库。按年,月,日查询

select * from pop where year(pdate)=年份  and month(pdate)>1 and month(pdate)<3

select * from Mall_Coupons where year(StartDate)=2011 and month(StartDate)>12 and month(StartDate)<2
posted @ 2016-07-29 14:06  离。  阅读(78)  评论(0编辑  收藏  举报