title: Manipulate the results of getdate() for databases in different time zones
body: <p>I have an application with limited support for running in different time zones.  Essentially, the application has one database/environment for the west cost, and one for the east cost.</p>
  
  <p>The applications figures the current time using getdate().</p>
  
  <p>We don't have source code, so replacing getdate with a custom function isn't an option.  Is there some way over overriding the Getdate function?  Or is it possible to configure a different time zone for different databases?  What about different instances?</p>