I know, this is what I have:
or do you mean something else?
The first query on my MS SQL database is:
SELECT * FROM *.*Kontakt WHERE FORMAT(ErstelltAm, 'yyyy-MM-dd') = CAST(GETDATE() AS DATE)
the second query is like in the screenshot above and I get this error:
{"status":"500","code":"ER_PARSE_ERROR","message":"SELECT * FROM *_*Kontakt WHERE (Date(ErstelltAm) = CURDATE()) AND KontaktId NOT IN '3627C28C-898A-4768-AD09-5614F3D4318C' - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''3627C28C-898A-4768-AD09-5614F3D4318C'' at line 1","stack":"Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''3627C28C-898A-4768-AD09-5614F3D4318C'' at line 1
at Query.Sequence._packetToError (/*/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Query.ErrorPacket (/*/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
at Protocol._parsePacket (/*/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/*/node_modules/mysql/lib/protocol/Parser.js:433:10)\n at Parser.write (/*/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/*/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at TLSSocket.ondata (internal/streams/readable.js:719:22)
at TLSSocket.emit (events.js:315:20)
at addChunk (internal/streams/readable.js:309:12)\n at readableAddChunk (internal/streams/readable.js:284:9)
--------------------
at Protocol._enqueue (/*/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Connection.query (/*/node_modules/mysql/lib/Connection.js:198:25)
at /*/node_modules/knex/lib/dialects/mysql/index.js:132:18
at new Promise (<anonymous>)
at Client_MySQL._query (/*/node_modules/knex/lib/dialects/mysql/index.js:126:12)
at executeQuery (/*/node_modules/knex/lib/execution/internal/query-executioner.js:37:17)
at Client_MySQL.query (/*/node_modules/knex/lib/client.js:144:12)
at Runner.query (/*/node_modules/knex/lib/execution/runner.js:130:36)
at ensureConnectionCallback (/*/node_modules/knex/lib/execution/internal/ensure-connection-callback.js:13:17)
at Runner.ensureConnection (/*/node_modules/knex/lib/execution/runner.js:272:20)"}