[Bug 121492] Base can not filter by dates

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=121492

--- Comment #6 from Andreas Säger <vi...@t-online.de> ---
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.