[METAMODEL-1112] Where clauses with Date related fields fail on SQL Server

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.5.4
• Labels: datetime sql sqlserver
• Environment: Running on Java 8 web server using Jersey to provide a REST API. DB is running on SQL Server 2012.
• Flags: Important
• Assignee: Unassigned
• Reporter: Harris Mirza
• Created: 15/Aug/16 09:05
• Updated: 21/Aug/17 03:17

Description

Hi, I noticed that when converting a query to SQL and using a condition that includes a date/time field the SQL doesn't run on SQL Server as it adds 'TIMESTAMP' before the value we are comparing. This is invalid syntax and I am not sure why this is added.

Thanks,
Harris Mirza

Issue Links

• links to: GitHub Pull Request #124