db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George Baklarz (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-163) Timestamp formatting
Date Fri, 04 Mar 2005 20:28:47 GMT
Timestamp formatting
--------------------

         Key: DERBY-163
         URL: http://issues.apache.org/jira/browse/DERBY-163
     Project: Derby
        Type: Bug
  Components: SQL  
    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.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Mime
View raw message