db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5596) TIMESTAMP doc gives wrong precision limitation
Date Fri, 06 Apr 2012 13:57:22 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Kim Haase updated DERBY-5596:

    Attachment: rrefsqlj27620.html

Since we keep getting questions about this, now seems a good time to fix it.

I'm attaching DERBY-5596.diff and rrefsqlj27620.html, with modifications to the "TIMESTAMP
data type" topic. Please let me know if changes are needed. 

I do have one question. Below the syntax it says, "The first of the two formats above is the
java.sql.Timestamp format." One naturally wonders, what is the second format? Do we have an
> TIMESTAMP doc gives wrong precision limitation
> ----------------------------------------------
>                 Key: DERBY-5596
>                 URL: https://issues.apache.org/jira/browse/DERBY-5596
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions:
>            Reporter: Dag H. Wanvik
>            Assignee: Kim Haase
>         Attachments: DERBY-5596.diff, rrefsqlj27620.html
> Derby accepts nanosecond fractions. e,g.
> create table t(i timestamp);
> insert into t values TIMESTAMP('1962-09-23 03:23:34.123456789');
> but the refman doc states:
> > Derby supports the following formats for TIMESTAMP:
> >
> > yyyy-mm-dd hh:mm:ss[.nnnnnn]
> > yyyy-mm-dd-hh.mm.ss[.nnnnnn]
> >
> > The first of the two formats above is the java.sql.Timestamp format.
> >
> >The year must always have four digits. Months, days, and hours may have one or two
digits. Minutes and seconds must have two digits. 
> >Nanoseconds, if present, may have between one and six digits.
> Nine digits are accepted, not six:
> select * from t;
> I                            
> -----------------------------
> 1962-09-23 03:23:34.123456789

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message