Prior to you SQL Query being sent to the database back-end ( I assume you are using HSQL Version 2.3.? or 2.4.? ,
NOT an Embedded Database ) . . . OpenOffice / LibreOffice Base will 'parse' - AKA
Base Parser - read the Query and make changes ( for example formatting of dates, or, prompt the user for input ). Unfortunately, the Base Parser will not accept ( allow ) that function ( actually, the INTERVAL part ).
Solution:
- Use the HSQL Function DATEADD instead. The syntax for your Query would be:
Code: Select all
select
"p_birthdate",
DATEADD('month', 3, "p_birthdate"
from "tbl_person"
- For the code exactly as you wrote it, prevent the Base Parser from making any changes to the Query, and, run the Query directly. Either
- From the Menu: Edit -> Run SQL Command directly[ should be checked
- On the Query Toolbar, click on the icon SQL with a green check mark.
I hope this helps, please be sure to let me / us know.
Sliderule
Thanks to add
[Solved] in your
1st post Subject (edit button top right) if this issue has been resolved.