declare @d date,@y varchar(8)select @d=getdate()while(@d<=cast('2099-12-31' as date))begin select @y=convert(varchar,@d,112) if @y=reverse(@y) print cast(cast(@y as date) as varchar) select @d=dateadd(d,1,@d)end-- 结果2011-11-022020-02-022021-12-022030-03-022040-04-022050-05-022060-06-022070-07-022080-08-022090-09-02