数据库用select语句查询闰年

create function [dbo].[fn_IsLeapYear]

(

@year int

)

returns varchar(14)

as begin

declare @returnvalue int

----varchar(14)

declare @setvalue int

set @setvalue=datepart(mm,dateadd(dd,1,cast((cast(@year as varchar(4))+ '0228') as datetime)))

if(@setvalue=2)

set @returnvalue=1

---@returnvalue='闰年'

else

set @returnvalue=0

---@returnvalue='非闰年'

----return (cast (@year as varchar(8))+'年:'+@returnvalue)

return @returnvalue

end

GO

--sqlserver

declare @Year int

set @Year = YEAR(GETDATE())

if @Year % 4 = 0

select '闰年'

else

select '非闰年'

Scanner scan = new Scanner(System.in)

int input = scan.nextInt()

if ((input % 4 == 0 &&input % 100 != 0)

|| (input % 4 == 0 &&input % 100 == 0))

System.out.println(input + "年是闰年")

else

System.out.println(input + "年是平年")

---