Hi 向金 郭,
I hope ddd is the input variable.
Try following query:
select EXTRACT(MONTH from TIMESTAMP [[ddd]]);
input variable should not be in quotes.
It works fine for me.
I hope it helps.
Hi Xiang Jing Guo,
Have you tried with adding "Date/Time stamp" pattern in your query?
Like 'dd-mm-yyyy, yyyy-mm-dd' etc.
In my scenario, I used as suggested by Ankit and added specific pattern and it works,
select * from "FOO"
I will suggest, first try to run the query which you are looking for on your database and then replicate it on ThingWorx.
Hope it helps.