SQL Syntax Error, not my query

Question

I was given some SQL to run against our db and it is throwing a syntax error. I have looked through and cannot find the missing expression. Can anyone please assist? It says line 6 column 42, which correlates to the first "ts".

Thanks, Andrew

SELECT "IWRKGRPQUEUESTATS"."CNAME", "IWRKGRPQUEUESTATS"."CHKEY3", "IWRKGRPQUEUESTATS"."NENTEREDACD", "IWRKGRPQUEUESTATS"."NINTERNTOEXTERNCALLS", "IWRKGRPQUEUESTATS"."NANSWEREDACD", "IWRKGRPQUEUESTATS"."TANSWEREDACD", "IWRKGRPQUEUESTATS"."TTALKACD", "IWRKGRPQUEUESTATS"."CHKEY4", "IWRKGRPQUEUESTATS"."DINTERVALSTART", "IWRKGRPQUEUESTATS"."NHOLDACD", "IWRKGRPQUEUESTATS"."THOLDACD", "IWRKGRPQUEUESTATS"."NABANDONEDACD", "IWRKGRPQUEUESTATS"."NABANDONACDSVCLVL1", "IWRKGRPQUEUESTATS"."NABANDONACDSVCLVL2", "IWRKGRPQUEUESTATS"."NABANDONACDSVCLVL3", "IWRKGRPQUEUESTATS"."NABANDONACDSVCLVL4"
FROM "ADMIN"."IWRKGRPQUEUESTATS" "IWRKGRPQUEUESTATS"
WHERE "IWRKGRPQUEUESTATS"."CHKEY4"=N'*' AND "IWRKGRPQUEUESTATS"."CHKEY3"<>N'*' 
AND ("IWRKGRPQUEUESTATS"."CNAME">=N'ATEAM' 
AND "IWRKGRPQUEUESTATS"."CNAME"<=N'STORES') 
AND ("IWRKGRPQUEUESTATS"."DINTERVALSTART">={ts '2016-08-17 00:00:00'} 
AND "IWRKGRPQUEUESTATS"."DINTERVALSTART"<{ts '2016-08-17 23:59:59'})
ORDER BY "IWRKGRPQUEUESTATS"."CNAME";

@DanBracuk: no, that's a valid SQL "nvarchar" literal (I think that is even part of the SQL standard - but at least Postgres, Oracle and SQL Server support that) — user330315
– user330315, Commented Oct 7, 2016 at 13:36

user330315 · Accepted Answer · 2016-10-07 13:37:18Z

1

{ts '2016-08-17 23:59:59'} is an escape sequence for JDBC (and I think ODBC as well).

Those escape sequences are (have to be) converted by the client side (driver) to a proper syntax before the statement is sent to the server.

So whatever SQL client you are using it apparently doesn't support that (it's not using JDBC or ODBC)

answered Oct 7, 2016 at 13:37

user330315

Sign up to request clarification or add additional context in comments.

2 Comments

AWooster Over a year ago

I am using Oracle SQL Developer if that helps. Should I change the "ts" to "to_date" and format that way?

user330315 Over a year ago

@AWooster: Hmm, that's strange SQL Developer uses JDBC but it indeed complains for some reason (but I stopped trying to understand Oracle's decisions regarding their feature implementations). You might want to ask in Oracle's SQL Developer forum why that valid JDBC expression is rejected by SQL Developer

Collectives™ on Stack Overflow

SQL Syntax Error, not my query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related