Changing the output of Getdate

Posted by pauloya on Stack Overflow See other posts from Stack Overflow or by pauloya
Published on 2010-04-07T14:01:10Z Indexed on 2010/04/07 14:03 UTC
Read the original article Hit count: 197

Filed under:
|

Is it possible to deceive SQL Server to return a different date on GetDate() without actually changing the machine date?
This would be great, since we have a database with old data and I'm trying to test some queries that use getdate().
I can change my machine date but that brings some other problems with other applications...
Any tips?
Thanks!

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about getdate