摘要:
SELECT birthday, CAST(CAST(datepart(yy, getdate()) AS varchar(20)) + '-' + CAST(datepart(mm, birthday) AS varchar(20)) + '-' + CAST(datepart(day, birthday) AS varchar(20)) AS datetime) AS Nbirthday FROM CRM_CustomerWHERE birthday is not NULLAND (//当前时间要大于等于生日Datediff(day,CAST(CAST(da 阅读全文