kou2pinso

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

Hi,

 

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..

 

 

 

 

 

 

Outcomes