select * 
from lkitem  
where rncid=787 
	and purpose='Commercial Project' 
	and status='LK Released' 
	AND entity = 'RNC'
	and (decision_time is not null)
order by decision_time DESC


-------------------------------------
--求最近三个月即将到期的
SELECT a.expiretime,a.status,a.purpose,a.* 
FROM lkitem a
WHERE a.entity = 'RNC' AND a.status = 'LK Released' AND a.purpose = 'External Trial' AND a.province = '浙江'
	AND a.expiretime >= (SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) 'thetime')
	AND a.expiretime < (SELECT dateadd(mm,2,(SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0)))) 'thetime')
ORDER BY a.expiretime asc

-------------------------------------
--查询系统当前日期
SELECT convert(VARCHAR(10),getdate(),120) 'thetime'
--查询从系统当前日期算3个月后的日期
SELECT dateadd(mm,3,(SELECT convert(VARCHAR(10),getdate(),120) 'thetime'))
--查询本月的第一天
SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
--查询本月的最后一天
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))
--查询上一个月的最后一天
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(mm,0,getdate()), 0))

--查询本月的第一天
SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
--从本月的第一天开始算，查询第三个月的最后一天
SELECT dateadd(mm,2,(SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))))