db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From j..@apache.org
Subject svn commit: r168252 - /incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita /incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita /incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita
Date Thu, 05 May 2005 03:40:33 GMT
Author: jta
Date: Wed May  4 20:40:33 2005
New Revision: 168252

URL: http://svn.apache.org/viewcvs?rev=168252&view=rev
Log:
Applied patch for DERBY-234

Modified:
    incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita
    incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita
    incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita

Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita?rev=168252&r1=168251&r2=168252&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj18730.dita Wed May  4 20:40:33 2005
@@ -1,4 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
 <!-- 
 Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
 
@@ -14,9 +16,6 @@
 See the License for the specific language governing permissions and  
 limitations under the License.
 -->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
 <reference id="rrefsqlj18730" xml:lang="en-us">
 <title>DATE</title>
 <prolog><metadata>
@@ -27,13 +26,21 @@
 by <i>java.sql.Date</i>. </p></section>
 <refsyn><title>Syntax</title> <codeblock><b>DATE</b></codeblock>
</refsyn>
 <section><title>Corresponding compile-time Java type</title> <p><i>java.sql.Date</i></p>
</section>
-<section><title>JDBC metadata type (java.sql.Types)</title> <p>DATE</p>
<p>Dates,
-times, and timestamps must not be mixed with one another in expressions.</p> <p>Any
+<section><title>JDBC metadata type (java.sql.Types)</title><p>DATE</p><p>Dates,
+times, and timestamps must not be mixed with one another in expressions.</p><p>Any
 value that is recognized by the <i>java.sql.Date</i> method is permitted in
-a column of the corresponding SQL date/time data type.</p> </section>
-<example> <codeblock><b>VALUES DATE('1994-02-23')
+a column of the corresponding SQL date/time data type. <ph conref="refconrefs.dita#prod/productshortname"></ph>
supports
+the following formats for DATE:<codeblock>yyyy-mm-dd
+mm/dd/yyyy
+dd.mm.yyyy</codeblock>The first of the three formats above is the <i>java.sql.Date</i>
format.</p><p>The
+year must always be expressed with four digits, while months and days may
+have either one or two digits.</p><p><ph conref="refconrefs.dita#prod/productshortname"></ph>
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.</p> </section>
+<example> <title>Examples</title><codeblock><b>VALUES DATE('1994-02-23')
 
 VALUES '1993-09-01'</b></codeblock> </example>
 </refbody>
 </reference>
-<?Pub *0000001126?>
+<?Pub *0000002340?>

Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita?rev=168252&r1=168251&r2=168252&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita Wed May  4 20:40:33 2005
@@ -1,4 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
 <!-- 
 Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
 
@@ -14,27 +16,30 @@
 See the License for the specific language governing permissions and  
 limitations under the License.
 -->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
 <reference id="rrefsqlj21908" xml:lang="en-us">
 <title>TIME</title>
 <prolog><metadata>
 <keywords><indexterm>TIME data type</indexterm></keywords>
 </metadata></prolog>
 <refbody>
-<section> <p>TIME provides for storage of an hour-minutes-seconds-fractional-seconds
-value with six digits in the fractional-seconds part. <ph conref="refconrefs.dita#prod/productshortname"></ph>
also
-supports the ISO format of 8 characters (6 digits, and 2 decimal points).</p></section>
-<refsyn><title>Syntax</title> <codeblock><b>TIME</b></codeblock>
</refsyn>
-<section><title>Corresponding compile-time Java type</title> <p><i>java.sql.Time</i></p>
</section>
-<section><title>JDBC metadata type (java.sql.Types)</title> <p>TIME</p>
<p>Dates,
+<section> <p>TIME provides for storage of a time-of-day value.</p></section>
+<refsyn><title>Syntax</title><codeblock><b>TIME</b></codeblock>
</refsyn>
+<section><title>Corresponding compile-time Java type</title><p><i>java.sql.Time</i></p>
</section>
+<section><title>JDBC metadata type (java.sql.Types)</title><p>TIME</p><p>Dates,
 times, and timestamps cannot be mixed with one another in expressions except
-with a CAST.</p> <p>Any value that is recognized by the <i>java.sql.Time</i>
method
-is permitted in a column of the corresponding SQL date/time data type.</p> </section>
-<section><title>Related information</title> <codeblock><b>TIME'HH:MM:SS[.FFFFFF']</b></codeblock>
</section>
-<example> <codeblock><b>VALUES TIME('15:09:02')
+with a CAST.</p><p>Any value that is recognized by the <i>java.sql.Time</i>
method
+is permitted in a column of the corresponding SQL date/time data type. <ph
+conref="refconrefs.dita#prod/productshortname"></ph> supports the following
+formats for TIME:<codeblock>hh:mm[:ss]
+hh.mm[.ss]
+hh[:mm] {AM | PM}</codeblock>The first of the three formats above is the <i>java.sql.Time</i>
format.</p><p>Hours
+may have one or two digits. Minutes and seconds, if present, must have two
+digits.</p><p><ph conref="refconrefs.dita#prod/productshortname"></ph>
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.</p> </section>
+<example> <title>Examples</title><codeblock><b>VALUES TIME('15:09:02')
 VALUES '15:09:02'</b></codeblock> </example>
 </refbody>
 </reference>
-<?Pub *0000001414?>
+<?Pub *0000002292?>

Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita?rev=168252&r1=168251&r2=168252&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj27620.dita Wed May  4 20:40:33 2005
@@ -1,4 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
 <!-- 
 Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
 
@@ -14,9 +16,6 @@
 See the License for the specific language governing permissions and  
 limitations under the License.
 -->
-
-<!DOCTYPE reference PUBLIC "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
 <reference id="rrefsqlj27620" xml:lang="en-us">
 <title>TIMESTAMP</title>
 <prolog><metadata>
@@ -24,19 +23,24 @@
 </metadata></prolog>
 <refbody>
 <section> <p>TIMESTAMP stores a combined DATE and TIME value to be stored.
-It permits a fractional-seconds value of up to nine digits. <ph conref="refconrefs.dita#prod/productshortname"></ph>
also
-supports the ISO format of 23 characters (17 digits, 3 dashes, and 3 decimal
-points).</p></section>
-<refsyn><title>Syntax</title> <codeblock><b>TIMESTAMP</b></codeblock>
</refsyn>
-<section><title>Corresponding compile-time Java type</title> <p><i>java.sql.Timestamp</i></p>
</section>
-<section><title>JDBC metadata type (java.sql.Types)</title> <p>TIMESTAMP</p>
<p>Dates,
-times, and timestamps cannot be mixed with one another in expressions.</p> <p>Timestamp
-only accepts formats accepted by Timestamp.valueOf. Any value that is recognized
-by the <i>java.sql.Timestamp valueOf(String)</i> method is permitted in a
-column of the corresponding SQL date/time data type.</p> </section>
-<example> <codeblock><b>VALUES '1960-01-01 23:03:20'
+It permits a fractional-seconds value of up to nine digits.</p></section>
+<refsyn><title>Syntax</title><codeblock><b>TIMESTAMP</b></codeblock>
</refsyn>
+<section><title>Corresponding compile-time Java type</title><p><i>java.sql.Timestamp</i></p>
</section>
+<section><title>JDBC metadata type (java.sql.Types)</title><p>TIMESTAMP</p><p>Dates,
+times, and timestamps cannot be mixed with one another in expressions.</p><p><ph
+conref="refconrefs.dita#prod/productshortname"></ph> supports the following
+formats for TIMESTAMP:<codeblock>yyyy-mm-dd hh[:mm[:ss[.nnnnnn]]]
+yyyy-mm-dd-hh[.mm[.ss[.nnnnnn]]]</codeblock>The first of the two formats above
+is the <i>java.sql.Timestamp</i> format.</p><p>The year must always
have four
+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 between
+one and six digits.</p><p><ph conref="refconrefs.dita#prod/productshortname"></ph>
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.</p> </section>
+<example> <title>Examples</title><codeblock><b>VALUES '1960-01-01
23:03:20'
 VALUES TIMESTAMP('1962-09-23 03:23:34.234')
 VALUES TIMESTAMP('1960-01-01 23:03:20')</b></codeblock> </example>
 </refbody>
 </reference>
-<?Pub *0000001473?>
+<?Pub *0000002458?>



Mime
View raw message