CREATE DEFINER = `root`@`%` FUNCTION `NewProc`()
RETURNS int(11)
BEGIN
#进行判断当前是平年还是闰年
DECLARE yea int;
DECLARE num int;
DECLARE isfour int;
set num = 365;
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(now()),'%Y') into yea;
set isfour = yea%100;
if(isfour = 0)THEN
if(yea%400 = 0)THEN
set num = 366;
end if;
else
if(yea%4 = 0)THEN
set num = 366;
end if;
end if;
RETURN num;
RETURNS int(11)
BEGIN
#进行判断当前是平年还是闰年
DECLARE yea int;
DECLARE num int;
DECLARE isfour int;
set num = 365;
SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(now()),'%Y') into yea;
set isfour = yea%100;
if(isfour = 0)THEN
if(yea%400 = 0)THEN
set num = 366;
end if;
else
if(yea%4 = 0)THEN
set num = 366;
end if;
end if;
RETURN num;
END;
mysql function判断 当前年份是 平年闰年