MSSQL中取今天谁生日

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