https://bugs.documentfoundation.org/show_bug.cgi?id=104918

--- Comment #2 from Gerhard Schaber <gerhard.scha...@gmx.at> ---
The same with Version: 6.1.0.0.alpha0+, Build ID:
864ab0502a4d3506413451e8c545144c6c15d777.

"SQL Status: HY000
Error code: 1000

syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
"

When I run something like this:
SELECT DATEDIFF (DAY FROM DATE '2017-03-30' to DATE '2018-03-31') FROM
RDB$DATABASE
or this:
SELECT DATEDIFF (DAY, CAST('2018-03-30' AS DATE), CAST('2018-03-31' AS DATE))
FROM RDB$DATABASE
in Tools > SQL..., LO freezes.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to