MSSQL中取今天谁生日

select * from tEmployee
 where CONVERT(varchar(5),生日字段,10)=CONVERT(varchar(5),getdate(),10)