sql datetime 比较

select datediff(day,'2008-09-09','2008-9-7')

 

 

select   *   
  from   dddd   
  where   datediff(day,startDate,'2005-6-7')   <=0   and   datediff(day,endDate,'2006-7-23')   >=0