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 ka...@apache.org on 2006/04/04 14:17:19 UTC

svn commit: r391286 - in /db/derby/docs/trunk/src/ref: refderby.ditamap rrefjdbc12124.dita rrefjdbcescapedate.dita

Author: kahatlen
Date: Tue Apr  4 05:17:17 2006
New Revision: 391286

URL: http://svn.apache.org/viewcvs?rev=391286&view=rev
Log:
DERBY-724: Derby supports JDBC date escape format but this is not
documented

Attached patch adds a new topic in the JDBC escaped formats area of
the ref manual. The new topic describes the date escaped syntax.

Patch contributed by Jeff Levitt <de...@mylevita.com>.

Added:
    db/derby/docs/trunk/src/ref/rrefjdbcescapedate.dita   (with props)
Modified:
    db/derby/docs/trunk/src/ref/refderby.ditamap
    db/derby/docs/trunk/src/ref/rrefjdbc12124.dita

Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewcvs/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=391286&r1=391285&r2=391286&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Tue Apr  4 05:17:17 2006
@@ -430,7 +430,9 @@
 </topicref>
 <topicref href="rrefjdbc37244.dita" navtitle="JDBC escape syntax for outer joins">
 </topicref>
-<topicref href="rrefjdbc12124.dita" navtitle="JDBC espace syntax for time formats">
+<topicref href="rrefjdbc12124.dita" navtitle="JDBC escape syntax for time formats">
+</topicref>
+<topicref href="rrefjdbcescapedate.dita" navtitle="JDBC escape syntax for date formats">
 </topicref>
 <topicref href="rrefjdbc41784.dita" navtitle="JDBC escape syntax for timestamp formats">
 </topicref>

Modified: db/derby/docs/trunk/src/ref/rrefjdbc12124.dita
URL: http://svn.apache.org/viewcvs/db/derby/docs/trunk/src/ref/rrefjdbc12124.dita?rev=391286&r1=391285&r2=391286&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbc12124.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefjdbc12124.dita Tue Apr  4 05:17:17 2006
@@ -1,4 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
 <!-- 
 Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.  
 
@@ -14,11 +16,8 @@
 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="rrefjdbc12124" xml:lang="en-us">
-<title>JDBC espace syntax for time formats</title>
+<title>JDBC escape syntax for time formats</title>
 <prolog><metadata>
 <keywords><indexterm>t (JDBC escape keyword)</indexterm><indexterm>{t (JDBC
 escape syntax)</indexterm><indexterm>JDBC escape syntax for</indexterm><indexterm>Time
@@ -29,9 +28,8 @@
 the JDBC escape syntax for time as equivalent to the correct SQL syntax for
 times. <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>{t 'hh:mm:ss'}</b></codeblock> </refsyn>
-<section><title>Equivalent to</title> <codeblock><b>TIME 'hh:mm:ss'</b></codeblock> </section>
-<example> <codeblock><b>VALUES {t '20:00:03'}</b></codeblock> </example>
+<refsyn><title>Syntax</title><codeblock><b>{t 'hh:mm:ss'}</b></codeblock> </refsyn>
+<section><title>Equivalent to</title><codeblock><b>TIME 'hh:mm:ss'</b></codeblock> </section>
+<example> <title>Example</title><codeblock><b>VALUES {t '20:00:03'}</b></codeblock> </example>
 </refbody>
 </reference>
-

Added: db/derby/docs/trunk/src/ref/rrefjdbcescapedate.dita
URL: http://svn.apache.org/viewcvs/db/derby/docs/trunk/src/ref/rrefjdbcescapedate.dita?rev=391286&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefjdbcescapedate.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefjdbcescapedate.dita Tue Apr  4 05:17:17 2006
@@ -0,0 +1,34 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "reference.dtd">
+<!-- 
+Copyright 1997, 2006 The Apache Software Foundation or its licensors, as applicable.  
+
+Licensed under the Apache License, Version 2.0 (the "License");  
+you may not use this file except in compliance with the License.  
+You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rrefjdbcescapedate" xml:lang="en-us">
+<title>JDBC escape syntax for date formats</title>
+<prolog><metadata>
+<keywords><indexterm>d (JDBC escape keyword)</indexterm><indexterm>{d (JDBC
+escape syntax)</indexterm><indexterm>JDBC escape syntax for</indexterm><indexterm>Date
+formats</indexterm></keywords>
+</metadata></prolog>
+<refbody>
+<section> <p><ph conref="refconrefs.dita#prod/productshortname"></ph> interprets
+the JDBC escape syntax for dates as equivalent to the correct SQL syntax for
+dates.</p></section>
+<refsyn><title>Syntax</title><codeblock><b>{d 'yyyy-mm-dd'}</b></codeblock> </refsyn>
+<section><title>Equivalent to</title><codeblock><b>DATE 'yyyy-mm-dd'</b></codeblock> </section>
+<example> <title>Example</title><codeblock><b>VALUES {d '1995-12-19'}</b></codeblock> </example>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rrefjdbcescapedate.dita
------------------------------------------------------------------------------
    svn:eol-style = native