db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-234) Documentation of DateTime types is incomplete
Date Thu, 04 Jan 2007 23:32:27 GMT

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

Bryan Pendleton commented on DERBY-234:

Many thanks for the good discussion! After digesting these comments for a few days, I've come
to the conclusion that I should commit the current mmss_required.diff. I believe it makes
the doc more accurately describe the behavior of the code, which is reason enough to commit
it as is, I think.

> Documentation of DateTime types is incomplete
> ---------------------------------------------
>                 Key: DERBY-234
>                 URL: https://issues.apache.org/jira/browse/DERBY-234
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions:
>            Reporter: Jack Klebanoff
>         Assigned To: Bryan Pendleton
>            Priority: Minor
>         Attachments: derby234.diff, mmss_required.diff, rrefsqlj27620.html
> The documentation for datatypes DATE, TIME, and TIMESTAMP is incomplete. The documentation
says that DATE, TIME, and TIMESTAMP accept any values accepted by the java.sql.Date, java.sql.Time,
and java.sql.Timestamp classes respectively. Derby accepts a number of string formats:
>   yyyy-mm-dd
>   mm/dd/yyyy
>   dd.mm.yyyy
>   hh:mm[:ss]
>   hh.mm[.ss]
>   hh[:mm] {AM | PM}
>   yyyy-mm-dd-hh[.mm[.ss[.nnnnnn]]]
>   yyyy-mm-dd hh[:mm[:ss[.nnnnnn]]]
> The year must always have 4 digits. Months, days, and hours may have one or two digits.
Minutes and seconds, if present, must have two digits. Nanoseconds, if present may have 1
to 6 digits.
> Derby also accepts strings in the locale specific datetime format, using the locale of
the database server. If there is an ambiguity the built in formats above take precedence.

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


View raw message