To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=98479
User fs changed the following:
What |Old value |New value
================================================================================
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from f...@openoffice.org Tue Feb 3 14:20:20 +0000
2009 -------
sorry, invalid.
When dealing with dates as mere numeric values, you always have to take into
account the so-called "null date". That is, for a given date, when converting it
to a numeric value (a long, in Basic), this is the number of days which passed
since the "null date". For basic, this null date is the 30.12.1899. So, all
conversions between "Long" and "Date" in Basic use the 30.12.1899 as reference
value. Consequently, a "Long" value of "0" corresponds to the 30.12.1899, a
"Long" value of "2" corresponds to the 1.1.1900, and so on.
In databases, however, the null date is the 1.1.1900. So, whenever you convert a
database date to a long value (and this is what you do when calling getLong at a
database column, containing a date), then the "null date" 1.1.1900 is applied.
In other words, when you insist on implicitly converting dates to numeric
values, it's your responsibility to care for different null dates which exist in
different systems.
---------------------------------------------------------------------
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
