AnsweredAssumed Answered

I am trying in MS-SQL to write: SELECT [tag],[time],[value],[status] ,[timestep]  FROM [PI].[piarchive]..[piinterp2] Where tag = 'sinusoid' and [time] between '*-1h' and '*'and [timestep] = '30m' GO

Question asked by BjaNyg on Nov 4, 2019
Latest reply on Nov 5, 2019 by jyi

I am trying in MS-SQL to write:

 

SELECT [tag],[time],[value],[status] ,[timestep]  

FROM [PI].[piarchive]..[piinterp2]

Where tag = 'sinusoid' and [time] between '*-1h' and '*'and [timestep] = '30m'

GO

 

but I end up with the error:

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date and/or time from character string.

 

 

Any suggestions to what is wrong?

Outcomes