[
https://issues.apache.org/jira/browse/DERBY-163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492973
]
Kathey Marsden commented on DERBY-163:
--------------------------------------
I noticed in converting the ParameterMappingTest to junit these differences
between embedded and client
case java.sql.Types.TIMESTAMP:
if (param == 2)
if (usingEmbedded())
assertEquals("2004-03-12 21:14:24.938222433",
val.toString());
else
assertEquals("2004-03-12 21:14:24.938222", val.toString());
else if (param == 3)
if (usingEmbedded())
assertEquals("2004-04-12 04:25:26.462983731",
val.toString());
else
assertEquals("2004-04-12 04:25:26.462983", val.toString());
break;
Is that difference the same as this bug or is it a different issue?
> Timestamp formatting
> --------------------
>
> Key: DERBY-163
> URL: https://issues.apache.org/jira/browse/DERBY-163
> Project: Derby
> Issue Type: Bug
> Components: Newcomer, SQL
> Affects Versions: 10.0.2.0
> Environment: Windows XP Professional SP1
> Reporter: George Baklarz
> Priority: Minor
>
> The timestamp format within Derby contains the following information:
> yyyy-mm-dd-hh.mm.ss.mmmmmm
> When issuing a CURRENT TIMESTAMP function, it returns
> yyyy-mm-dd-hh.mm.ss.mmm
> If you do a TIMESTAMP('1988-12-15-17.12.30.123400') it will return
> 1988-12-15-17.12.30.1234
> Is there any particular reason why Derby does not display the zeros at the
> end of the field? This may just be just to be consistent with the ISO
> standards, but if you look at the example in the manual, it shows:
> VALUES TIMESTAMP(START_DATE, END_DATE)
> 1988-12-25-17.12.30.000000
> If I try this with a simple table:
> CREATE TABLE TS (A DATE, B TIME);
> INSERT INTO TS VALUES (CURRENT DATE, CURRENT TIME);
> SELECT TIMESTAMP(A,B) FROM TS;
> ij> select timestamp(a,b) from ts;
> 1
> --------------------------
> 2005-03-04 15:13:19.0
> So the 0's are not displayed, except for the first microsecond. The format
> needs to be clarified either in the manuals or corrected in the program.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
