db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jack Klebanoff (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-234) Documentation of DateTime types is incomplete
Date Fri, 22 Apr 2005 15:53:24 GMT
Documentation of DateTime types is incomplete
---------------------------------------------

         Key: DERBY-234
         URL: http://issues.apache.org/jira/browse/DERBY-234
     Project: Derby
        Type: Bug
  Components: Documentation  
    Versions: 10.0.2.0    
    Reporter: Jack Klebanoff
    Priority: Minor


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:

DATE:
  yyyy-mm-dd
  mm/dd/yyyy
  dd.mm.yyyy

TIME:
  hh:mm[:ss]
  hh.mm[.ss]
  hh[:mm] {AM | PM}

TIMESTAMP:
  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:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message