Author: plavin
Date: 2007-03-12 21:42:27 +0100 (Mon, 12 Mar 2007)
New Revision: 5317
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:40:13 UTC (rev 5316)
+++ trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-12 20:42:27 UTC (rev 5317)
Changed blocks: 8, Lines Added: 53, Lines Deleted: 38; 6519 bytes
@@ -1533,10 +1533,11 @@
<function id="subtime" class="datetime">
<display>SUBTIME()</display>
- <description lang="en"></description>
+ <description lang="en">Subtract times</description>
<arguments>
<format><![CDATA[<replaceable>expr1</replaceable>,<replaceable>expr2</replaceable>]]></format>
- <argument seq="1" name="expr" type="numeric"></argument>
+ <argument seq="1" name="expr" type="datetime"></argument>
+ <argument seq="1" name="expr" type="datetime"></argument>
</arguments>
<return type="numeric"/>
<error type="return"/>
@@ -1547,14 +1548,13 @@
</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"/>
+ <function id="sysdate" class="datetime">
+ <display>SYSDATE()</display>
+ <description lang="en">Returns the time at which the function executes</description>
+ <!-- Returns the current date and time as a value in
+ 'YYYY-MM-DD HH:MM:SS' or
+ YYYYMMDDHHMMSS format -->
+ <return type="date"/>
<error type="return"/>
<versions>
<manual version="4.1"/>
@@ -1563,12 +1563,13 @@
</versions>
</function>
- <function id="" class="">
- <display></display>
- <description lang="en"></description>
+ <function id="time" class="datetime">
+ <display>TIME()</display>
+ <description lang="en">Extract the time portion of the expression passed</description>
<arguments>
- <format><![CDATA[]]></format>
- <argument seq="1" name="expr" type="numeric"></argument>
+ <format><![CDATA[<replaceable>expr</replaceable>]]></format>
+ <argument seq="1" name="expr" type="datetime">Date</argument>
+ <argument seq="1" name="expr" type="string">Properly formated string</argument>
</arguments>
<return type="numeric"/>
<error type="return"/>
@@ -1579,14 +1580,15 @@
</versions>
</function>
- <function id="" class="">
- <display></display>
+ <function id="timediff" class="datetime">
+ <display>TIMEDIFF()</display>
<description lang="en"></description>
<arguments>
- <format><![CDATA[]]></format>
- <argument seq="1" name="expr" type="numeric"></argument>
+ <format><![CDATA[<replaceable>expr1</replaceable>,<replaceable>expr2</replaceable>]]></format>
+ <argument seq="1" name="expr" type="string">Properly formated string</argument>
+ <argument seq="1" name="expr" type="string">Properly formated string</argument>
</arguments>
- <return type="numeric"/>
+ <return type="string"/>
<error type="return"/>
<versions>
<manual version="4.1"/>
@@ -1595,14 +1597,20 @@
</versions>
</function>
- <function id="" class="">
- <display></display>
- <description lang="en"></description>
+ <function id="timestamp" class="datetime">
+ <display>TIMESTAMP()</display>
+ <description lang="en">With a single argument, this function returns the date or
+ datetime expression. With two arguments, the sum of the arguments</description>
<arguments>
- <format><![CDATA[]]></format>
- <argument seq="1" name="expr" type="numeric"></argument>
+ <format><![CDATA[<replaceable>expr1</replaceable>,<replaceable>expr2</replaceable>]]></format>
+ <argument seq="1" name="expr" type="string">Properly formated string</argument>
+ <argument seq="2" name="expr" type="string">Properly formated string</argument>
</arguments>
- <return type="numeric"/>
+ <arguments>
+ <format><![CDATA[<replaceable>expr1</replaceable>,<replaceable>expr2</replaceable>]]></format>
+ <argument seq="1" name="expr" type="string">Properly formated string</argument>
+ </arguments>
+ <return type="date"/>
<error type="return"/>
<versions>
<manual version="4.1"/>
@@ -1611,12 +1619,15 @@
</versions>
</function>
- <function id="" class="">
- <display></display>
+ <function id="timestampadd" class="datetime">
+ <display>TIMESTAMPADD()</display>
<description lang="en"></description>
<arguments>
- <format><![CDATA[]]></format>
- <argument seq="1" name="expr" type="numeric"></argument>
+ <format><![CDATA[<replaceable>unit</replaceable>,
+ <replaceable>interval</replaceable>,<replaceable>datetime_expr</replaceable>]]></format>
+ <argument seq="1" name="expr" type="string">Time unit</argument>
+ <argument seq="2" name="expr" type="numeric">Number of units</argument>
+ <argument seq="3" name="expr" type="string">Properly formated string</argument>
</arguments>
<return type="numeric"/>
<error type="return"/>
@@ -1627,12 +1638,15 @@
</versions>
</function>
- <function id="" class="">
- <display></display>
+ <function id="timestampdiff" class="datetime">
+ <display>TIMESTAMPDIFF()</display>
<description lang="en"></description>
<arguments>
- <format><![CDATA[]]></format>
- <argument seq="1" name="expr" type="numeric"></argument>
+ <format><![CDATA[<replaceable>unit</replaceable>,<replaceable>datetime_expr1</replaceable>,
+ <replaceable>datetime_expr2</replaceable>]]></format>
+ <argument seq="1" name="expr" type="numeric">Time unit</argument>
+ <argument seq="2" name="expr" type="numeric">Properly formated string</argument>
+ <argument seq="3" name="expr" type="numeric">Properly formated string</argument>
</arguments>
<return type="numeric"/>
<error type="return"/>
@@ -1643,12 +1657,13 @@
</versions>
</function>
- <function id="" class="">
- <display></display>
+ <function id="time-format" class="datetime">
+ <display>TIME_FORMAT()</display>
<description lang="en"></description>
<arguments>
- <format><![CDATA[]]></format>
- <argument seq="1" name="expr" type="numeric"></argument>
+ <format><![CDATA[<replaceable>time</replaceable>,<replaceable>format</replaceable>]]></format>
+ <argument seq="1" name="expr" type="time"></argument>
+ <argument seq="1" name="expr" type="string">Properly formated string</argument>
</arguments>
<return type="numeric"/>
<error type="return"/>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5317 - trunk/dynamic-docs/opsfunctions | plavin | 12 Mar |
