Tuesday, 14 June 2016

Sql Data spoofing for datetime

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