See https://calcite.apache.org/docs/reference.html#keywords <https://calcite.apache.org/docs/reference.html#keywords>. TIMESTAMP occurs in bold, therefore it is a reserved keyword.
> On Mar 24, 2019, at 3:54 PM, Julian Hyde <[email protected]> wrote: > > TIMESTAMP is a reserved keyword in both Calcite and the SQL standard. > > If you insist on using it as a table or column name, you must enclose it in > double-quotes when you use it in a query. > > Julian > > >> On Mar 22, 2019, at 5:22 AM, YuZhao Chen <[email protected]> wrote: >> >> timestamp is neither a keyword nor a builtin function in Calcite now, so >> what is the stackTrace your query throw ? Can you show us more details ? >> >> Best, >> Danny Chan >> >> Suhail Aliyar <[email protected]> 于2019年3月22日周五 上午2:26写道： >> >>> Hello, >>> >>> I am Suhail Aliyar, Backend developer at dexlock technologies, Kochi, >>> India. >>> >>> I am using calcite server for validating SQL queries in my MSSQL server >>> using java in my application. While using your latest version(1.18.0) from >>> maven, The validator throws exceptions. The queries are given below. I have >>> tried the same queries from DBeaver and I am able to fetch results. >>> >>> Sample Queries: >>> 1. select timeStamp from <table name>; >>> 2. SELECT *, FLOOR(timeStamp / (1000)) % 60 AS seconds FROM >>> dbo.enriched_video >>> 3. SELECT *, CONVERT(VARCHAR,DATEADD(ms,timestamp,0),108) AS time FROM >>> dbo.enriched_video >>> >>> In my table I have a attribute names "timeStamp". >>> >>> Can anyone please provide me some quick help to make support to these >>> keywords. Thanks for helping. >>> >>> *Thanks & Regards* >>> *Suhail Aliyar* >>> *Software Engineer* >>> *Mob:+91 9846449816* >>> *Website: www.dexlock.com <http://www.dexlock.com>* >>> >
