Différences

Ci-dessous, les différences entre deux révisions de la page.

--- tma:tam_montpellier [03/04/2019 17:04] – [Automates Twido (Stations)] gautier.bejuit
+++ tma:tam_montpellier [03/04/2019 17:11] (Version actuelle) – [Conversion Chrono en DateTime] gautier.bejuit
@@ Ligne 80: / Ligne 80: @@
 Pour convertir cela en date classique, il faut utiliser par exemple:\\
 \\
-SELECT Chrono,Name,Value,Quality,TS FROM TRENDTABLE1
+__**Dans un WHERE:**__\\
-where Chrono > (cast( DATEDIFF(second,convert(datetime, '1970-01-01 00:00:00',121) ,convert(datetime, '2007-05-25 09:00:00',121))as bigint)* 10000000)+ 116444736000000000
+\\
-and Chrono < (cast( DATEDIFF(second,convert(datetime, '1970-01-01 00:00:00',121) ,convert(datetime, '2007-05-25 10:00:00',121))as bigint)* 10000000)+ 116444736000000000 order by TS
+SELECT Chrono,Name,Value,Quality,TS FROM TRENDTABLE1\\
+where Chrono > (cast( DATEDIFF(second,convert(datetime, '1970-01-01 00:00:00',121) ,convert(datetime, '2007-05-25 09:00:00',121))as bigint)* 10000000)+ 116444736000000000\\
+and Chrono < (cast( DATEDIFF(second,convert(datetime, '1970-01-01 00:00:00',121) ,convert(datetime, '2007-05-25 10:00:00',121))as bigint)* 10000000)+ 116444736000000000\\
+order by TS\\
+\\
+\\
+__**Dans un Select:**__\\
+\\
+Select Chrono, DATEADD(s, (Chrono - 116444736000000000)/10000000 , '1970-01-01 00:00:00') as Date, Name, Value\\
+FROM [BASE_SQL].[dbo].[TABLE1]\\
+\\
 {{tag>TMA, Montpellier, PCVue, Twido, Net Sentinel,TAM, Tramway}}

Wiki