T-SQL version of MySQL CURTIME ()

Question

I am trying to get the current time as a unix timestamp from my MSSQL database.

In Mysql, I could say something like:

SELECT id, caregiver_id, client_id, week_no, CURTIME() as Synch_Time FROM dbo.Visits 

But in T-SQL there is no CURTIME () function

Does anyone know of a solution?

thanks

Kevin

Answer 1

You can use getdate () and perform some of the calculations described here. http://mysql.databases.aspfaq.com/how-do-i-convert-a-sql-server-datetime-value-to-a-unix-timestamp.html

Answer 2

getdate() is MSSQL specific, but current_timestamp() is more standard. See Similar question: Getting date on sql server, CURRENT_TIMESTAMP and GetDate ()

Answer 3

In SQL2012, usage can be converted to certain types of date and time, for example.

  SELECT Time = CONVERT(TIME, GETDATE()), Date = CONVERT(DATE, GETDATE())