declare @date datetime = getdate()
declare @intdate int = 0
declare @realdate decimal(20,9) = 0
declare @i int = 10
print @date
select @intdate = cast(@date as int)
print @intdate
select @realdate = cast(@date as decimal(20,9))
print @realdate
while @i >0
begin
select @realdate = @realdate + cast(datepart(ms,getdate()) as decimal (18,6))/1000
select @date = cast(@realdate as datetime)
print cast(@realdate as varchar) + ' or in long date format:' + cast(@date as varchar)
select @i = @i-1
end
declare @intdate int = 0
declare @realdate decimal(20,9) = 0
declare @i int = 10
print @date
select @intdate = cast(@date as int)
print @intdate
select @realdate = cast(@date as decimal(20,9))
print @realdate
while @i >0
begin
select @realdate = @realdate + cast(datepart(ms,getdate()) as decimal (18,6))/1000
select @date = cast(@realdate as datetime)
print cast(@realdate as varchar) + ' or in long date format:' + cast(@date as varchar)
select @i = @i-1
end