关于日期的查询

生日查询：（例如：8.1~8.15之间过生日的）

select * from presoninfo where

dateadd(year,datediff(year,flocktime,'2009-8-1'),flocktime)between '2009-8-1' and '2009-8-15'

or

dateadd(year,datediff(year,flocktime,'2009-8-15'),flocktime)between '2009-8-1' and '2009-8-15'

 

其中“presoninfo ”为表名，“flocktime”为相关字段名

----------------------------------------------------------------------------------------------------------------------------------------------

 

mysql下的另一种写法：

select * from tab_name where col_name like (select concat('%',(select date_format(NOW(),'-%m-%d')),'%'));

怎么样查询当天后15以内过生日的所有人？

<1>:

select   *   from   表  
    where    
  (datepart(month,getdate())<>12   and  
          datediff  
      (  
          day  
          ,getdate()  
          ,dateadd(year,datediff(year,出生日期字段,getdate()),出生日期字段)  
      )   between   0   and   15)  
  or    
  (datepart(month,getdate())=12   and  
          datediff  
      (  
          day  
          ,getdate()  
          ,dateadd(year,datediff(year,出生日期字段,getdate())-1,出生日期字段)  
      )   between   0   and   15)  

<2>:

select   *   from   表  
  where   datediff(day  
  ,dateadd(year,1900-year(getdate()),getdate())  
  ,dateadd(year,1900-year(dt),dt)  
  )   between   1   and   15