ODBC SQL Statement(AspenTech SQLplus)

[Bokangmaela]

Good day,

I am currently experiencing an issue querying MTD data using the odbc(AspenTech SQLplus) connection. 

My SQL statement looks like the following :

SELECT TS, Name, Value FROM History WHERE name = 'name' AND TS >= DATEADD(day, -30, GETDATE()) AND Period = '00:00:20';

When I run the command I get the following error:

ODBC: ERROR [HY000] Expecting expression, found reserved word "DAY"

I am not sure where I am going wrong, please advice.

Kind Regards

[swikritee_p]

@Bokangmaela , Try if the SQL given below, can help

SELECT TS, Name, Value 
FROM History 
WHERE Name = 'name' 
  AND TS >= (CURRENT_TIMESTAMP - INTERVAL '30' DAY)
  AND Period = '00:00:20';

[Bokangmaela]

@swikritee_p , Thanks for your reponse 

When I run the query I get the following error :

"ODBC: ERROR [HY000] Expecting expression, found reserved word "INTERVAL""