Bug 156751 - Add support for locale date formats in queries
Summary: Add support for locale date formats in queries
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: Queries (show other bugs)
Version: unspecified
Platform: Compiled Sources All
: NOR wishlist
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-01-27 00:18 UTC by Matija Šuklje
Modified: 2014-12-03 01:49 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 ;)