SQL QUERY by sqldas - how to get time UTC from SQL

Discussion created by kou2pinso on Jun 1, 2012
Latest reply on Jun 14, 2012 by kou2pinso



I have the query SQL,  :


SELECT tag, time, value, status
FROM [piarchive].[picomp2]
WHERE tag = 'sinusoid'
    AND time BETWEEN '*-1h' AND '*'




Could you explain me how to get from the attribut "time" in query SQL :


- the Universal Coordinate Time (UTC) from the "time" in long / to January 1, 1970


- The timezone from the "time"


thank you for your reply..