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