celso.martinez

Date Functions available in PI OLEDB Enterprise 2010 R3

Discussion created by celso.martinez on May 28, 2013
Latest reply on May 29, 2013 by michaelh

The question is simple, but I am not able to find any answer after read all documentation about PI OLEDB.

Given a datetime (eg. 20-feb-2013 10:00:00) retrieved through a SQL statement

select time, value from piarchive..picomp where tag ='sinusoid' and time between 't' and 't+10h'

How to retreive date information only (eg. 20-Feb-2013) instead of datetime (20-feb-2013 10:00:00)?

Is there any pifunction for this purpose?

Outcomes