To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94488
Issue #|94488
Summary|sql date value is off by two
Component|Database access
Version|OOO300m7
Platform|PC
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|fschuett
------- Additional comments from [EMAIL PROTECTED] Tue Sep 30 17:11:03 +0000
2008 -------
I created a new database and executed some sql statements to fill the
database with tables and data.
The table in question was created by the statement:
--------------------
CREATE TABLE "SCHUELER" (
"KENNR" VARCHAR(10) NOT NULL,
"NAME" VARCHAR(40),
"VORNAME" VARCHAR(40),
"GEBURTSTAG" DATE,
PRIMARY KEY ("KENNR"));
--------------------
Then I inserted a record by the statement:
--------------------
INSERT INTO "SCHUELER" VALUES (
'000',
'Thiedig', 'Oliver', '87-11-12');
I
--------------------
The statements were executed with success, but when I opened
the table I noticed that the value for "GEBURTSTAG" was
"87-11-14".
I could reproduce this behavior with about ten different
records.
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
