This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 69032 - Wrong displayed vaule for TIMESTAMP type
Summary: Wrong displayed vaule for TIMESTAMP type
Status: VERIFIED INVALID
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 5.x
Hardware: All All
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-11-21 11:54 UTC by Martin Schovanek
Modified: 2006-11-30 16:15 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

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

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Schovanek 2005-11-21 11:54:57 UTC 
[#200511201900, jdk1.5.0, Oracle 9i with 9.2 driver, Win XP]

to reproduce:
-------------
Have a XXX table with "x" TIMESTAMP column
1) insert '21-NOV-2005' and '11-JAN-2002' values into the column
2) run 'select 'x='||x, x from XXX' command
ERROR: the year value in both x columns is 2020!

The 'x=||x' column dispalys correct values.
Comment 1 Martin Schovanek 2005-11-21 14:44:15 UTC 
Pardon, wrong syntax in insert statement.
Comment 2 Martin Schovanek 2006-11-30 16:15:09 UTC 
v.