I am new to Valentina Server and am trying to execute some SQL for a SQLite database on the server. It seems that any SQL having to do with date functions is throwing kernel errors. For example: 08:28:55 Kernel error: 0x9050e. Error in function name "julianday". I am running this SQL elsewhere with no issue. I guess it may also be the Valentina Studio throwing these errors.
SQL - SELECT Date('now');
returns 08:39:29 Kernel error: 0x71000. line 2:12: expecting STRING_LITERAL, found '('
This SQL works fine in Studio when running against SQLite file.
Any ideas?