Author: plavin
Date: 2007-03-12 19:40:13 +0100 (Mon, 12 Mar 2007)
New Revision: 5316
Log:
Add more functions
Modified:
trunk/dynamic-docs/opsfunctions/opfunctions.xml
Modified: trunk/dynamic-docs/opsfunctions/opfunctions.xml
===================================================================
--- trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-12 18:07:33 UTC (rev 5315)
+++ trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-12 18:40:13 UTC (rev 5316)
Changed blocks: 3, Lines Added: 173, Lines Deleted: 2; 6289 bytes
@@ -1428,7 +1428,7 @@
<arguments>
<format><![CDATA[<replaceable>P1</replaceable>,<replaceable>P2</replaceable>]]></format>
<argument seq="1" name="expr" type="numeric">Format period YYMM or YYYYMM</argument>
- <argument seq="1" name="expr" type="numeric">Number of months</argument>
+ <argument seq="1" name="expr" type="numeric">Format period YYMM or YYYYMM</argument>
</arguments>
<return type="numeric"/>
<error type="return"/>
@@ -1455,6 +1455,98 @@
</versions>
</function>
+ <function id="second" class="datetime">
+ <display>SECOND()</display>
+ <description lang="en">Return the second (0-59)</description>
+ <arguments>
+ <format><![CDATA[<replaceable>time</replaceable>]]></format>
+ <argument seq="1" name="expr" type="datetime"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="sec-to-time" class="datetime">
+ <display>SEC_TO_TIME()</display>
+ <description lang="en">Converts seconds 'HH:MM:SS' format</description>
+ <arguments>
+ <format><![CDATA[<replaceable>seconds</replaceable>]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <!-- Correct return type? -->
+ <return type="string"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="str-to-date" class="datetime">
+ <display>STR_TO_DATE()</display>
+ <description lang="en">Convert a string to a date</description>
+ <arguments>
+ <format><![CDATA[<replaceable>str</replaceable>,<replaceable>format</replaceable>]]></format>
+ <argument seq="1" name="expr" type="string"></argument>
+ <argument seq="1" name="expr" type="string">Format string</argument>
+ </arguments>
+ <return type="date"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="subdate" class="datetime">
+ <display>SUBDATE()</display>
+ <description lang="en">When invoked with three arguments a synonym for DATE_SUB()</description>
+ <arguments>
+ <format><![CDATA[<replaceable>date</replaceable>,INTERVAL
+ <replaceable>expr</replaceable>
+ <replaceable>unit</replaceable>]]></format>
+ <argument seq="1" name="expr" type="date"></argument>
+ <argument seq="2" name="expr" type="numeric"></argument>
+ <argument seq="3" name="expr" type="string">Unit of time</argument>
+ </arguments>
+ <arguments>
+ <format><![CDATA[<replaceable>expr</replaceable>,<replaceable>days</replaceable>]]></format>
+ <argument seq="1" name="expr" type="date"></argument>
+ <argument seq="2" name="expr" type="numeric">Number of days</argument>
+ </arguments>
+
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="subtime" class="datetime">
+ <display>SUBTIME()</display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[<replaceable>expr1</replaceable>,<replaceable>expr2</replaceable>]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
<function id="" class="">
<display></display>
<description lang="en"></description>
@@ -1487,5 +1579,84 @@
</versions>
</function>
-
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
</opfunctions>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5316 - trunk/dynamic-docs/opsfunctions | plavin | 12 Mar |
