You can't get any information from SQL server unless you ask for it: and a SELECT query is pretty much the only way to do that. So try:
SELECT GETDATE()
But please, don't do it per second!
Why not just read it once when you app starts, and store it as:
DateTime serverTime = GetDateAndTimeFromSQL();
TimeSpan serverDiff = DateTime.Now - serverTime;
You can then use the TimeSpan value to work out what the server time is by adding the difference onto the current date and time for your machine. A re-check every couple of hours should keep them nicely in sync.