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>* >
