世界完全对称日(SQL)

ll32

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

view plain
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
测试代码:

view plain
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

测试结果

view plain
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

py1181

技术文章，支持！

amwdnuff

谢谢楼主分享了