https://bz.apache.org/ooo/show_bug.cgi?id=121492
--- Comment #28 from Kay <[email protected]> --- (In reply to mickey69 from comment #27) > @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 About the only way to check if it is a problem with the postgresql SDBC extension is to try to connect to your DB using another form of connector -- jdbc, etc. and see if the same problem occurs. Thanks for your investigation on this. -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue.
