Bug 156751

Summary: Add support for locale date formats in queries
Product: [Applications] KEXI Reporter: Matija Šuklje <matija>
Component: QueriesAssignee: Kexi Bugs <kexi-bugs>
Status: CONFIRMED ---    
Severity: wishlist    
Priority: NOR    
Version First Reported In: unspecified   
Target Milestone: ---   
Platform: Compiled Sources   
OS: All   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:

Description Matija Šuklje 2008-01-27 00:18:16 UTC 
Version:           1.6.3 (using KDE 3.5.8)
Installed from:    Gentoo Packages
OS:                Linux

In my case the locale is sl_SI.utf8 (i.e. Slovenian), but I suspect it's a global bug.

When I enter date fields in tables I can only use the locale format (i.e. dd.mm.yy), but although one would expect the same format to be used in the queries, it is not the case. The only one when writing queries that worked for me was the ISO format (i.e. yyyy-mm-dd).

What I would expect:
* coherent use of one (perferably locale) format in both table input and queries
Comment 1 Matija Šuklje 2008-01-27 10:04:50 UTC 
I suspect this is also the reason why using KexiReportPart (0.0.4) shows dates in the report in the ISO format.
Comment 2 Adam Pigg 2008-01-27 16:14:58 UTC 
Its probably not fair to put this as a bug against Kexi as my report part is a seperate project.  Its also in quite an infant stage, but i#ll do my best to fix reported bugs.  I'll also reply to your other email later.
Comment 3 Matija Šuklje 2008-01-27 16:23:17 UTC 
No, no. I've noticed the bug even before I used your KexiReportPart. I found that bug with the help of ingwa, SaroEngels, astan (and others) on the #koffice IRC channel when I was just trying to write a query that would show me only entries that are dated on a specific month.
Comment 4 Jarosław Staniek 2008-01-28 10:59:39 UTC 
The ISO format yyyy-mm-dd is used i nthe SQL language, especially in facilities behind the designer, namely SQL parser. 

We could support locale formats but need to find out a way to indicate a data constant is in locale format -- a way that can be considered as a standard.

So - later, plese remind for Kexi 2.x.
Comment 5 Matija Šuklje 2008-01-28 23:24:00 UTC 
Will do ;)