[dba-issues] [Issue 111679] Can't store milliseconds in Time Type.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111679 User mechtilde changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from mechti...@openoffice.org Sat May 22 08:47:15 + 2010 --- invalid - closed - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 111679] Can't store milliseconds in Time Type.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111679 Issue #|111679 Summary|Can't store milliseconds in Time Type. Component|Database access Version|OOO320m12 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|moreqs --- Additional comments from mor...@openoffice.org Tue May 18 10:45:23 + 2010 --- Can't store milliseconds in Time type. For example: Choose 'Time' for field Type and choose 00:00.00 format. Then enter data into the table field, for example 12:12.12 If I click in the next field to add another time value, 12:12.12 in the aforementioned field changes to 12:12.00 It's as if ooBase can't handle milliseconds. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 111679] Can't store milliseconds in Time Type.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111679 User r4zoli changed the following: What|Old value |New value CC|''|'r4zoli' Status|UNCONFIRMED |RESOLVED Resolution| |INVALID --- Additional comments from r4z...@openoffice.org Tue May 18 16:13:29 + 2010 --- Time type use hh:mm:ss format and not store milliseconds. See details in HSQLDB documentation: http://hsqldb.org/doc/guide/ch09.html#datatypes-section - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 111679] Can't store milliseconds in Time Type.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111679 --- Additional comments from mor...@openoffice.org Tue May 18 17:28:07 + 2010 --- Thanks for quick reply. So, not an error, but a Time data type from the last century. OOo Base provides the format 00:00.00 for Time, but that is misleading, as HSQLDB can't store milliseconds in Time. I need to add an 'improve Time datatype' to the wish list, (wherever that is). Let me know if this should be marked as closed .. (even though the issue is still an issue, but maybe not if there is a way around the problem, that has not dawned on me yet) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 111679] Can't store milliseconds in Time Type.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111679 --- Additional comments from r4z...@openoffice.org Tue May 18 17:45:04 + 2010 --- The next 2.0 version of HSQLDB support fractional seconds in time fields (it is in RC phase), when finished it is planned to be integrated into OOo 3.3. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
