https://bz.apache.org/ooo/show_bug.cgi?id=121492
--- Comment #24 from Kay <[email protected]> --- (In reply to mickey69 from comment #23) > 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 hmmm...well this is not good. Can you check the settings for your date field in the table you're using? When you open your DB, the tables should show up in the bottom pane. Just highlight (one click) on the table name, then use Edit from the toolbar to look at how your date field is defined. The syntax you used for your selection should work fine if your date field is defined this way. On tests I have done, no translation of the date as you indicate takes place. I have no experience with postgresql or the sdbc extension you're using, though. I hope this is not a factor. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
