[ http://issues.apache.org/jira/browse/DERBY-1803?page=all ]
Laura Stewart updated DERBY-1803: --------------------------------- Attachment: derby1803.diff derby1803_html.zip Updated the date/time limitations and the DATE function file. Included are a diff file and an html.zip file. > [DOC] Largest TIMESTAMP value in Derby limitations section of reference > manual is documented incorrectly > -------------------------------------------------------------------------------------------------------- > > Key: DERBY-1803 > URL: http://issues.apache.org/jira/browse/DERBY-1803 > Project: Derby > Issue Type: Bug > Components: Documentation > Affects Versions: 10.1.3.1 > Reporter: Susan Cline > Assigned To: Laura Stewart > Attachments: derby1803.diff, derby1803_html.zip > > > The documentation for the Largest TIMESTAMP value in the DATE, TIME and > TIMESTAMP limitations section of the Derby limitations of the reference > manual is incorrect. > http://db.apache.org/derby/docs/dev/ref/rrefdttlimits.html > The incorrectly stated value is 9999-12-31-24.00.00.000000 > The correct value should be 9999-12-31-23.59.59.999999 > I tested this on a 10.1.3 and the 10.2 beta releases. > ij> create table timestamp_tab(id integer, timestamp_col timestamp); > 0 rows inserted/updated/deleted > ij> insert into timestamp_tab values (2, '9999-12-31-23.59.59.999999'); > 1 row inserted/updated/deleted > ij> insert into timestamp_tab values (1, '9999-12-31-24.00.00.000000'); > ERROR 22007: The string representation of a datetime value is out of range. > C:\derby_home\derby_10.1.3\lib>java org.apache.derby.tools.sysinfo > ------------------ Java Information ------------------ > Java Version: 1.4.2_09 > Java Vendor: Sun Microsystems Inc. > Java home: C:\JDK\jdk1.4.2_09\jre > Java classpath: derby.jar;.;derbytools.jar;derbynet.jar;derbyclient.jar; > OS name: Windows XP > OS architecture: x86 > OS version: 5.1 > Java user name: slc > Java user home: C:\Documents and Settings\Administrator > Java user dir: C:\derby_home\derby_10.1.3\lib > java.specification.name: Java Platform API Specification > java.specification.version: 1.4 > --------- Derby Information -------- > JRE - JDBC: J2SE 1.4.2 - JDBC 3.0 > [C:\derby_home\derby_10.1.3\lib\derby.jar] 10.1.3.1 - (417277) > [C:\derby_home\derby_10.1.3\lib\derbytools.jar] 10.1.3.1 - (417277) > [C:\derby_home\derby_10.1.3\lib\derbynet.jar] 10.1.3.1 - (417277) > [C:\derby_home\derby_10.1.3\lib\derbyclient.jar] 10.1.3.1 - (417277) > ------------------------------------------------------ > ----------------- Locale Information ----------------- > ------------------------------------------------------ -- 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