Author: plavin
Date: 2007-03-12 16:56:59 +0100 (Mon, 12 Mar 2007)
New Revision: 5307
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 15:44:07 UTC (rev 5306)
+++ trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-12 15:56:59 UTC (rev 5307)
Changed blocks: 8, Lines Added: 193, Lines Deleted: 5; 7713 bytes
@@ -454,6 +454,7 @@
<function id="atan" class="mathematical">
<display>ATAN</display>
+ <display>ATAN2</display>
<description lang="en">Return the arc tangent</description>
<arguments>
<format><![CDATA[<replaceable>X</replaceable>]]></format>
@@ -875,7 +876,7 @@
<function id="adddate" class="date-time">
<display>ADDDATE</display>
- <description lang="en"></description>
+ <description lang="en">Add dates</description>
<arguments>
<format><![CDATA[
<replaceable>date</replaceable>,INTERVAL
@@ -899,6 +900,182 @@
</versions>
</function>
+ <function id="addtime" class="date-time">
+ <display>ADDTIME</display>
+ <description lang="en">Add time</description>
+ <arguments>
+ <format><![CDATA[<replaceable>expr1</replaceable>,<replaceable>expr2</replaceable>]]></format>
+ <argument seq="1" name="expr" type="date-time"></argument>
+ <argument seq="2" name="expr" type="time"></argument>
+ </arguments>
+ <return type="date-time"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+
+ <function id="convert_tz" class="date-time">
+ <display>CONVERT_TZ</display>
+ <description lang="en">Convert from one timezone to another</description>
+ <arguments>
+ <format><![CDATA[<replaceable>dt</replaceable>,<replaceable>from_tz</replaceable>,<replaceable>to_tz</replaceable>]]></format>
+ <argument seq="1" name="expr" type="date-time"></argument>
+ <argument seq="1" name="expr" type="timezone">From Timezone</argument>
+ <argument seq="1" name="expr" type="timezone">To timezone</argument>
+ </arguments>
+ <return type="date-time"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="curdate" class="date-time">
+ <display>CURDATE</display>
+ <description lang="en">Return the current date</description>
+
+ <return type="date-time"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+
+ <function id="current_date" class="date-time">
+ <display>CURRENT_DATE()</display>
+ <display>CURRENT_DATE</display>
+ <description lang="en">Synonyms for CURDATE()</description>
+
+ <return type="date-time"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="curtime" class="date-time">
+ <display>CURTIME()</display>
+ <description lang="en">Return the current time</description>
+
+ <return type="date-time"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+
+ <function id="current_time" class="date-time">
+ <display>CURRENT_TIME()</display>
+ <display>CURRENT_TIME</display>
+ <description lang="en">Synonyms for CURTIME()</description>
+
+ <return type="date-time"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="current_timestamp" class="date-time">
+ <display>CURRENT_TIMESTAMP()</display>
+ <display>CURRENT_TIMESTAMP</display>
+ <description lang="en">Synonyms for NOW()</description>
+
+ <return type="date-time"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="date" class="date-time">
+ <display>DATE()</display>
+ <description lang="en">Extract the date part of a date or datetime expression</description>
+ <arguments>
+ <format><![CDATA[<replaceable>expr</replaceable>]]></format>
+ <argument seq="1" name="expr" type="date-time"></argument>
+ </arguments>
+ <return type="date-time"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="date_diff" class="date-time">
+ <display>DATE_DIFF()</display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[<replaceable>expr1</replaceable>,<replaceable>expr2</replaceable>]]></format>
+ <argument seq="1" name="expr" type="date-time">minuend</argument>
+ <argument seq="2" name="expr" type="date-time">subtrahend</argument>
+ </arguments>
+ <return type="days"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="date_add" class="date-time">
+ <display>DATE_ADD()</display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[<replaceable>date</replaceable>,INTERVAL
+ <replaceable>expr</replaceable>
+ <replaceable>unit</replaceable>]]></format>
+ <argument seq="1" name="expr" type="date">Starting date</argument>
+ <argument seq="2" name="expr" type="numeric">Amount to be added</argument>
+ <argument seq="3" name="expr" type="string">What units of time</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="date_format" class="date-time">
+ <display>DATE_FORMAT()</display>
+ <description lang="en">Format date as specified</description>
+ <arguments>
+ <format><![CDATA[<replaceable>date</replaceable>,<replaceable>format</replaceable>]]></format>
+ <argument seq="1" name="expr" type="date"></argument>
+ <argument seq="2" name="expr" type="string">Format specifier</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>
@@ -915,7 +1092,6 @@
</versions>
</function>
-
<function id="" class="">
<display></display>
<description lang="en"></description>
@@ -948,7 +1124,6 @@
</versions>
</function>
-
<function id="" class="">
<display></display>
<description lang="en"></description>
@@ -981,7 +1156,6 @@
</versions>
</function>
-
<function id="" class="">
<display></display>
<description lang="en"></description>
@@ -997,6 +1171,21 @@
<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>
@@ -1015,5 +1204,4 @@
</function>
-
</opfunctions>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5307 - trunk/dynamic-docs/opsfunctions | plavin | 12 Mar |
