In postgresql i used:
current_date - interval ‘30’ day
when i run this query in base, i have a syntax error.
What can i do?
In postgresql i used:
current_date - interval ‘30’ day
when i run this query in base, i have a syntax error.
What can i do?
Hello,
The Base query window does some basic checking based upon using HSQLDB database (default). To bypass this you need to turn on Run SQL command directly
:
This is an icon on the toolbar and is a toggle. It is also available from the menu under Edit
.
exactly!
Saved by a button!
Thanks for the quick response.