You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by bp...@apache.org on 2007/01/05 04:51:06 UTC
svn commit: r492893 - in /db/derby/docs/trunk/src:
pt_BR/ref/rrefsqlj27620.dita ref/rrefsqlj27620.dita
Author: bpendleton
Date: Thu Jan 4 19:51:05 2007
New Revision: 492893
URL: http://svn.apache.org/viewvc?view=rev&rev=492893
Log:
DERBY-234: Documentation of DateTime types is incomplete
This patch modifies the doc for the timestamp datatype to reflect that with
the current code, the minutes and seconds portions of the timestamp are
not optional. Only the nanoseconds field is optional in the current code.
Modified:
db/derby/docs/trunk/src/pt_BR/ref/rrefsqlj27620.dita
db/derby/docs/trunk/src/ref/rrefsqlj27620.dita
Modified: db/derby/docs/trunk/src/pt_BR/ref/rrefsqlj27620.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/pt_BR/ref/rrefsqlj27620.dita?view=diff&rev=492893&r1=492892&r2=492893
==============================================================================
--- db/derby/docs/trunk/src/pt_BR/ref/rrefsqlj27620.dita (original)
+++ db/derby/docs/trunk/src/pt_BR/ref/rrefsqlj27620.dita Thu Jan 4 19:51:05 2007
@@ -46,8 +46,8 @@
exceto com CAST.</p>
<p>O <ph conref="refconrefs.dita#prod/productshortname"></ph>
suporta os seguintes formatos para TIMESTAMP:
-<codeblock>yyyy-mm-dd hh[:mm[:ss[.nnnnnn]]]
-yyyy-mm-dd-hh[.mm[.ss[.nnnnnn]]]</codeblock>
+<codeblock>yyyy-mm-dd hh:mm:ss[.nnnnnn]
+yyyy-mm-dd-hh.mm.ss[.nnnnnn]</codeblock>
O primeiro dos dois formatos acima é o formato de <i>java.sql.Timestamp</i>.</p>
<p>O ano sempre deve ter quatro dÃgitos. Os meses, dias e horas podem ter um
ou dois dÃgitos. Os minutos e os segundos, se estiverem presentes, devem ter
Modified: db/derby/docs/trunk/src/ref/rrefsqlj27620.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj27620.dita?view=diff&rev=492893&r1=492892&r2=492893
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj27620.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj27620.dita Thu Jan 4 19:51:05 2007
@@ -30,11 +30,11 @@
<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
+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
+digits. Months, days, and hours may have one or two digits. Minutes and seconds
+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