Issue 15557

Summary:	Dates displayed incorrectly with JDBC driver (mysql and postgresql)
Product:	Base	Reporter:	Unknown <non-migrated>
Component:	code	Assignee:	Frank Schönheit <frank.schoenheit>
Status:	CLOSED DUPLICATE	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1 Beta2
Target Milestone:	---
Hardware:	PC
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Unknown 2003-06-12 14:21:19 UTC

Dates are displayed incorrectly when using the JDBC drives. I have seen the
problem with both postgresql and mysql jdbc drivers. For example my database has
a date field with a date value of 2003-05-08 22:04:35-05. From the Table view
(Datasources->Datasource->Tables->Table) a date of 04/22/03 12:59 AM is
displayed. And, when I drag-n-drop the table to a spreadsheet a date of 07/30/03
11:04 am is displayed. I see the same results using OOo on both windows and linux.

Comment 1 Frank Schönheit 2003-07-15 09:24:51 UTC

I strongly suppose that this is a duplicate of issue 14997. The reason
for the latter was that TIMESTAMP fields were incorrectly read via
JDBC, regardless of the underlying database, or of what has been done
with the read data.
This here pretty much sounds this way, you're obviously talking about
a timestamp field (containing date _and_ time), too.

So I mark this as duplicate. Issue 14997 will be fixed in OOo 1.1, if
this bug here still happens for you there, then please re-open.

*** This issue has been marked as a duplicate of 14997 ***

Comment 2 Frank Schönheit 2003-07-15 09:25:04 UTC

closing

Comment 3 hans_werner67 2004-02-02 12:55:19 UTC

change subcomponent to 'none'