NormDoucet

PIOLEDB DATEADD() TRANSACT-SQL EQUIVALENT

Discussion created by NormDoucet on Feb 4, 2013
Latest reply on Feb 4, 2013 by mhamel

I've got a query that returns a tag, time, and value.  I would like to add 12 hours to the time as another column, say time2.

 

In most T-SQL compliant database you would call SELECT tag, time, value, DATEADD(hh, 12, time) time2.

 

This returns an unpleasant error in PIOLEDB.

 

I would appreciate any suggestions or alternatives to acheive the same result in PIOLEDB.

 

PI OLEDB 3.3.0.1

Outcomes