db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George Baklarz (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-163) Timestamp formatting
Date Wed, 02 May 2007 14:28:15 GMT

    [ https://issues.apache.org/jira/browse/DERBY-163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493110
] 

George Baklarz commented on DERBY-163:
--------------------------------------

Not sure if it is the same. I was getting truncation on the digits (which
does look similar to your code below) but I was getting less digits than
the documentation suggested I should get. Your code shows 6 or 9
microseconds, while mine was being truncated at 4 instead of 6. Anyway, I
haven't followed up on this since it wasn't a current issue for me.

Thanks.

George


> 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.


Mime
View raw message