世界完全对称日(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

测试结果

2001-10-02 2010-01-02 2011-11-02 2020-02-02 2021-12-02 2030-03-02 2040-04-02 2050-05-02 2060-06-02 2070-07-02 2080-08-02 2090-09-02 2101-10-12 2110-01-12 2111-11-12 2120-02-12 2121-12-12 2130-03-12 2140-04-12 2150-05-12 2160-06-12 2170-07-12 2180-08-12 2190-09-12 2201-10-22 2210-01-22 2211-11-22 2220-02-22 2221-12-22 2230-03-22 2240-04-22 2250-05-22 2260-06-22 2270-07-22 2280-08-22 2290-09-22