sql server 常用sql

  

  --本周记录 
SELECT * FROM "jeecms"."dbo"."ORDER_INFO" WHERE datediff(week,O_I_G_DATE,getdate())=0 

--本月记录 
        SELECT * FROM    "jeecms"."dbo"."ORDER_INFO"  WHERE datediff(month,O_I_G_DATE,getdate())=0 

  -- 最近三个月
select * From "jeecms"."dbo"."ORDER_INFO" where O_I_G_DATE between dateadd(mm,-3,getdate()) and getdate()