select cast(cast('1 Jan 2010' as datetime) as int); --returns 40177 select cast(cast('27 Apr 2011' as datetime) as int) - cast(cast('1 Jan 2010' as datetime) as int); --returns 481 update transactions set requesteddatetimeutc = cast((RAND(convert(varbinary,newid()))*481 + 40177) as datetime);
No comments:
Post a Comment