Sql Server部分函数（实时更新）

1、获取生日为指定日期的数据

select * from people_table where MONTH(C_BIRTHDAY) = MONTH(GETDATE()) and DAY(C_BIRTHDAY) = DAY(GETDATE());
select * from people_table where MONTH(C_BIRTHDAY) = '02' and DAY(C_BIRTHDAY) = '29';