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?