Issue 15557 - Dates displayed incorrectly with JDBC driver (mysql and postgresql)
Summary: Dates displayed incorrectly with JDBC driver (mysql and postgresql)
Status: CLOSED DUPLICATE of issue 14997
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: Frank Schönheit
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-06-12 14:21 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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'