MYSQL计算两个日期年差函数

2012-08-31 21:27 DeguangLi 阅读(479) 评论(0) 收藏举报

CREATE DEFINER=`root`@`localhost` FUNCTION `DiffYear`(`inDate` date) RETURNS int(11)
BEGIN
    DECLARE curDate date;
    SET curDate =CURDATE();

    RETURN (YEAR(curDate)-YEAR(inDate)) - (RIGHT(inDate,5) > RIGHT(curDate,5));
END