Parent Directory | Revision Log | Patch
--- incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita 2005/05/05 03:40:02 168251 +++ incubator/derby/docs/trunk/src/ref/rrefsqlj21908.dita 2005/05/05 03:40:33 168252 @@ -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 @@ WITHOUT WARRANTIES OR CONDITIONS OF ANY 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?>
infrastructure at apache.org | ViewVC Help |
Powered by ViewVC 1.1.26 |