I am trying in MS-SQL to write:
SELECT [tag],[time],[value],[status] ,[timestep]
Where tag = 'sinusoid' and [time] between '*-1h' and '*'and [timestep] = '30m'
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?