Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012

    Unanswered: SQl Server date forward on instance

    Hi, I have the need to set the date in the future, for testing purposes on an instance of SQL Server 2012. I cannot do this on the server, as we have more than one instance running. Is it possible to set one instance's date 8 months in the future?

    Thanks for any advice

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Without using Virtualization, I don't know of any way to advance the clock of one SQL Server instance on a given Windows machine.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2007
    Provided Answers: 12
    GetDate() -
    Returns the current database system timestamp as a datetime value without the database time zone offset. This value is derived from the operating system of the computer on which the instance of SQL Server is running.
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts