Date Format for a SQL (OSISOFT PI)
Hi, after some trying i was able to get data from our PI Archive. We use PI (Osisoft) to archive our process data.With the following query I got the data but the timestamp is not there:SELECT t1.tag, t1.time, t1.value, t1.svalue, t1.status, t1.flags FROM picomp t1 WHERE ( ( ( t1.tag = 'AL2_Geschwindigkeit_Linienmotor_Formerstation' ) AND ( (t1.time >= ( '2017/03/05 1:47:16 PM' )) AND (t1.time <...