Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Prompted Querys should always accept unambigious Date/Time formats (ISO notation) | ||
---|---|---|---|
Product: | Base | Reporter: | jeffos2 <jeffos2> |
Component: | code | Assignee: | marc.neumann |
Status: | CLOSED FIXED | QA Contact: | issues@dba <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | OOo 1.1 RC3 | ||
Target Milestone: | OOo 2.0 | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
jeffos2
2003-08-28 02:44:24 UTC
Jeffery, thanks for filing this. The notation you refer to (YYYY-MM-DD) is know as ISO notation :) - adding this to the summary fs->oj: This is related to the internal bug 109202 - but neither of the two is a real duplicate of the other one. re-assigning, confirming, targeting noticed a little bit too late that you talked about a general delimiter, not only '-'. I am uncertain if this would be a good idea, since I don't know the relevance of other delimiters 'd' in a YYYYdMMdDD notation. E.g. (correct me if I'm wrong) the usual format for the english-us locale is DD/MM/YYYY - is YYYY/MM/DD really used? Furthermore, there may be locales (I don't know, but OOo supports such a huge amount of them, that we cannot be sure :) where the *default* notation would be YYYY.DD.MM - who knows? In such a locale, accepting YYYY.MM.DD would be disastrous. IOW, I tend to saying we should accept the ISO notation, but not arbitrary delimiters, as we maybe cannot guarantee that this is unambiguous in all locales. For english locales the format is MM/DD/YYYY. Well, I certainly am not going to speak for the entire English speaking world. :-) But here in the USA MM/DD/YYYY is the common format, two digit year with leading zeros ommited for MM and DD being the most common. But the YYYY/MM/DD format is also seen frequently. I agree with your example and conclusion and will be happy with a solution that allows ISO formats. Thanks, Jeff The parser now accepts also the ISO format YYYY-MM-DD. If you want this to work in your current installtion, you have to select your table in the broser (F4) and change the format of the date column (right mousr click on header) to ISO. After that, you can enter ISO format into the query design. Fixed in CWS oj07 Best regards, Ocke change subcomponent to 'none' . verify in cws oj07 verify in cws oj07 Hi, fixed in current developer build -> close. The current developer build can be found at http://download.openoffice.org/680/index.html Feel free to reopen if this issue is not fixed in the developer build. Bye Marc |