写一个函数检测:思路简单不再描述
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,@startda