In developer life date is role play most important part. So, I decided today make table contains all type of format. All type of format show in the table.
create proc getdateFormat
as
begin
create table #temp (id int identity(1,1),value varchar(max))
declare @temp int=0
while @temp<300
begin
if(@temp<15)
begin
insert into #temp(value) select CONVERT(varchar(max),getdate(),@temp)
set @temp+=1
end
else
begin
if(@temp=15)
begin
set @temp=100
end
else
begin
insert into #temp(value) select CONVERT(varchar(max),getdate(),@temp)
set @temp+=1
if(@temp=114)
begin
break;
end
end
end
end
select * from #temp
end