世界完全对称日(SQL)

写一个函数检测：思路简单不再描述

Create function dbo.IsSymmetryDate
(
	 @datetime as datetime
)returns bit
as
begin
declare @dateYY as char(4),@dateDDMM as char(4),@flag as bit
	set @dateYY=Substring(convert(char(8),@datetime,112),1,4)
	set @dateDDMM=Substring(convert(char(8),@datetime,112),5,4)
	if (REVERSE(@dateYY)=@dateDDMM)
	begin
		set @flag=1
	end
	else
	begin
		set @flag=0
	end
return @flag
end

测试代码:

declare @startdate as datetime,@enddate as datetime
set @startdate='2000-01-01'
set @enddate='3000-01-01'
while (@startdate <= @enddate)
begin
     if (dbo.IsSymmetryDate(@startdate)=1)
		begin
              print convert(char(10),@startdate,120)
        end
	
        set @startdate = dateadd(day,1,@startdate)
end

测试结果