title: How to use SQL Server's GETDATE() when system time is off?
body: <p>I'm writing an application which needs the accurate time (accurate to a few seconds, nothing crazy). The application is in C# and it interfaces with SQL Server, both reside on the same machine. In my application code I'm getting the time from an NTP server but I want to be able to write SQL statements which use GETDATE() instead of having to write the current time in the SQL statement.</p>
  
  <p>Unfortunately, the system time on the server doesn't stay accurate over time. Is there a way to use GETDATE() when the system time is off? I'd rather avoid writing code which retrieves the time from an NTP server and then updates the system time.</p>