1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
SELECT ajout.Repere AS Code,
convert(varchar(4),datepart(yy,time),10)
+'/'+RIGHT ('0'+convert(varchar(3),datepart(mm,time),10),2)
+'/'+RIGHT ('0'+convert(varchar(3),datepart(dd,time),10),2)
+' '+RIGHT ('0'+convert(varchar(3),datepart(hh,time),10),2)
+':'+RIGHT ('0'+convert(varchar(3),datepart(mi,time),10),2)
+':'+RIGHT ('0'+convert(varchar(3),datepart(ss,time),10),2) as Date,
Cumul AS Valeur,
Index.Unit
FROM ajout
INNER JOIN Index ON ajout.Repere=Index.Repere
WHERE DATEDIFF(d,time,GETUTCDATE())=1
ORDER BY time, ajout.Repere |
Partager