https://bz.apache.org/ooo/show_bug.cgi?id=121492
--- Comment #27 from mickey69 <[email protected]> --- @Kay: Field name: DateField Field type: Date [ date ] (entry required: no, Format example: 01/01/00, no default value) If I open the table, I see correct date value. @Andreas Säger: I try the same query in a Base DBMS table (no sdbc to another DBMS) and it works fine. In the query designer the "parsed SQL mode" is always on... In effects parsed mode may work regardless of the database backend... If I miss hashes writing the date in the GUI, they are correctly complemented (it works) Maybe a problem in the postgresql sdbc extension?? Some advice about the best Open Office <-> postgresql connector? When I run the query I receive this error: Error code: 1 pq_driver: [PGRES_FATAL_ERROR]ERRORE: errore di sintassi a o presso "{" al carattere 83 (caused by statement 'SELECT "DateField" FROM "base"."MyTable" AS "MyTable" WHERE "DateField" = {D '2015-01-01' }') (Traslation: ERROR: syntax error at or near "{" at character 83..." The query written with 'Design view mode' off, 'parsed SQL mode' on SELECT "DateField" FROM "base"."MyTable" AS "MyTable" WHERE "DateField" = '2015-01-01' works fine. Thanks for your answers -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue.
