https://issues.apache.org/ooo/show_bug.cgi?id=121492
--- Comment #6 from Andreas Säger <[email protected]> --- Hanya wrote: > I do not know '{D ''2013-01-10'' }' is correct SQL statement but > once I remove braces and D it worked with HSQLDB. According to the F1-help on queries (unaltered since version 1) his is what is supposed to work with Base: <quote> Date fields are represented as #Date# to clearly identify them as dates. The date condition will be reproduced in the resulting SQL statement in the following ODBC - compliant way: Date {D'YYYY-MM-DD'} Date time {D'YYYY-MM-DD HH:MM:SS'} Time {D'HH:MM:SS'} OpenOffice.org also supports the following Escape sequences known from ODBC and JDBC: Date {d 'YYYY-MM-DD'} Time {t 'HH:MI:SS[.SS]'} - [ ] optional DateTime {ts 'YYYY-MM-DD HH:MI:SS[.SS]'} - [ ] optional </quote> The #Date# syntax is for the GUI only. It supports locale specific input. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug.
