title: T-SQL version of MySQLs CURTIME()
body: <p>I am trying to get teh current time as a unix timestamp from my MSSQL database.</p>
  
  <p>In Mysql I could say something like:</p>
  
  <pre><code>SELECT id,
              caregiver_id,
              client_id,
              week_no,
              CURTIME() as Synch_Time
  FROM dbo.Visits 
  </code></pre>
  
  <p>But THERE is no CURTIME() function in T-SQL</p>
  
  <p>Does anyone know of a solution?</p>
  
  <p>Thanks</p>
  
  <p>Kevin</p>