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

Reply via email to