db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From t...@apache.org
Subject svn commit: r512226 - /db/derby/docs/trunk/src/ref/rrefminutefunc.dita
Date Tue, 27 Feb 2007 12:11:08 GMT
Author: tmnk
Date: Tue Feb 27 04:11:05 2007
New Revision: 512226

URL: http://svn.apache.org/viewvc?view=rev&rev=512226
Log:
- DERBY-908 YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on
durations / An example in minute page was for duration - Patch by Bryan Pendleton(bpendleton@amberpoint.com)

Modified:
    db/derby/docs/trunk/src/ref/rrefminutefunc.dita

Modified: db/derby/docs/trunk/src/ref/rrefminutefunc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefminutefunc.dita?view=diff&rev=512226&r1=512225&r2=512226
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefminutefunc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefminutefunc.dita Tue Feb 27 04:11:05 2007
@@ -34,7 +34,8 @@
 </p></section>
 <refsyn><title>Syntax</title> <codeblock><b>MINUTE ( <i>expression</i>
)</b></codeblock> </refsyn>
 <example>  <title>Example</title>
-<p>Select all classes that do not end on a full hour: </p>
-<codeblock><b>SELECT * FROM table1 WHERE MINUTE(ending) &lt; 60;</b></codeblock>
</example>
+<p>Select all rows from the "flights" table where the "departure_time"
+is between 6:00 and 6:30 AM: </p>
+<codeblock><b>SELECT * FROM flights WHERE HOUR(departure_time) = 6 and MINUTE(departure_time)
&lt; 31;</b></codeblock> </example>
 </refbody>
 </reference>



Mime
View raw message