title: Replace time part with custom time
body: <p>I have a scenario where I have to match the system time, but I have to match the current time with a pre-set saved datetime variable in sql server.</p>
  
  <pre><code>DECLARE @SyncDate AS DATETIME
  DECLARE @SystemDate AS DATETIME
  SELECT  @SyncDate = dbo.TimeTable.auto_time    
  FROM    dbo.TimeTable
  '1900-01-01 03:00
  SELECT  @SystemDate = GETDATE()
  </code></pre>
  
  <p>I have to replace the <code>@SyncDate</code> with current date and already saved time, i.e:</p>
  
  <pre><code>2015-11-16 03:00
  </code></pre>
  
  <p>Any body can help?</p>