sql 时间类型转换 时间比较

select datediff(day,OpenTime,getdate()) as t1,datediff(day,getdate(),'20081231'),
* from judgePara where DeclareTypeID in (select DeclareTypeID from ExpertGroup where expertID=5963 and judgeYear=2008)
 and judgeYear=2008 order by OpenTime

select CAST ( '20081231' AS datetime )

select convert (datetime,'20081231',111)