https://bz.apache.org/ooo/show_bug.cgi?id=121492
mickey69 <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |arda.tn.it --- Comment #23 from mickey69 <[email protected]> --- I installed the 4.2.0 version proposed in https://ci.apache.org/projects/openoffice/install/win/ (O.S. Win 7 - 64 bit) I installed the postgresql-sdbc-0.7.6b extension too, to connecting to my Postgresql 9.3 DBMS In the query designer (Design View) I build a query like "select DateField from MyTable where DateField = '2015-01-01' " (I select by double click the field 'DateField' in the table 'MyTable' and I write '2015-01-01' in the Criterion cell) Traslation in SQL code by OOBase is "SELECT "DateField" FROM "MyTable" WHERE "DateField" = {D '2015-01-01' }. Same traslation if in the query designer I write #2015-01-01# Postgresql doesen't recognise this syntax ( {D '2015-01-01' } ); correct syntax may be '2015-01-01' or date '2015-01-01' Do I write something wrong in the designer query? Maybe I can set some Base option? Thank you in advance Michela Piva -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
