Author: jstephens
Date: 2006-04-01 12:02:42 +0200 (Sat, 01 Apr 2006)
New Revision: 1714
Log:
Event start, end, and last executed times are shown using UT.
(Fixes Docs Bug #17835)
Modified:
trunk/refman-5.1/events.xml
trunk/refman-5.1/information-schema.xml
trunk/refman-5.1/sql-syntax.xml
Modified: trunk/refman-5.1/events.xml
===================================================================
--- trunk/refman-5.1/events.xml 2006-03-31 15:12:39 UTC (rev 1713)
+++ trunk/refman-5.1/events.xml 2006-04-01 10:02:42 UTC (rev 1714)
@@ -622,6 +622,18 @@
<literal>ENDS</literal>, both, or neither in an
<literal>EVERY</literal> clause.
</para>
+
+ <para>
+ <emphasis role="bold">Note</emphasis>: Where
+ <literal>STARTS</literal> or <literal>ENDS</literal> is
+ given as a datetime value, it is taken to mean local time on
+ the server. However, the values for both of these are
+ reported using Universal Time in the
+ <literal>INFORMATION_SCHEMA.EVENTS</literal> and
+ <literal>mysql.event</literal> tables, as well as in the
+ output from <literal>SHOW EVENTS</literal>. For additional
+ information, see <xref linkend="events-table"/>.
+ </para>
</listitem>
</itemizedlist>
Modified: trunk/refman-5.1/information-schema.xml
===================================================================
--- trunk/refman-5.1/information-schema.xml 2006-03-31 15:12:39 UTC (rev 1713)
+++ trunk/refman-5.1/information-schema.xml 2006-04-01 10:02:42 UTC (rev 1714)
@@ -3986,7 +3986,7 @@
INTERVAL_VALUE: 1
INTERVAL_FIELD: INTERVAL_DAY
SQL_MODE: NULL
- STARTS: 2006-02-10 20:41:23
+ STARTS: 2006-02-09 10:41:23
ENDS: NULL
STATUS: ENABLED
ON_COMPLETION: DROP
@@ -3997,6 +3997,39 @@
clears the table once per day.
1 row in set (0.50 sec)
</programlisting>
+
+ <para>
+ <emphasis role="bold">Important</emphasis>: The times displayed
+ by the <literal>STARTS</literal>, <literal>ENDS</literal>, and
+ <literal>LAST_EXECUTED</literal> columns are always given in terms
+ of Universal Time (GMT or UTC), regardless of the the server's
+ time zone setting. (The same is true for the
+ <literal>starts</literal>, <literal>ends</literal>, and
+ <literal>last_executed</literal> columns of the
+ <literal>mysql.event</literal> table and the
+ <literal>Starts</literal> and <literal>Ends</literal> columns in
+ the output of <literal>SHOW [FULL] EVENTS</literal>.) The
+ <literal>CREATED</literal> and <literal>LAST_ALTERED</literal>
+ columns use the server time zone (as do the
+ <literal>created</literal> and <literal>last_altered</literal>
+ columns of the <literal>mysql.event</literal> table).
+ </para>
+
+ <para>
+ For example, the <literal>e_daily</literal> event shown previously
+ was created on a computer in Brisbane, Australia, at 14:35:35 on
+ the 9<superscript>th</superscript> of February, 2006, Eastern
+ Australia Standard Time, which can also be expressed as the
+ <literal>GMT+10.00</literal> time zone. The event definition was
+ updated (using <literal>ALTER EVENT</literal> as shown earlier in
+ this section) a few minutes later, at 14:41:23. These are the
+ values displayed for <literal>CREATED</literal> and
+ <literal>LAST_ALTERED</literal>. The event is scheduled to begin
+ executing 6 hours later — that is, at 20:41:23 on the same
+ date, local time. Subtracting 10 hours from this to obtain
+ Universal Time yields 10:41:23, and it is this value that is shown
+ for <literal>STARTS</literal>.
+ </para>
<para>
See also <xref linkend="show-events"/>.
Modified: trunk/refman-5.1/sql-syntax.xml
===================================================================
--- trunk/refman-5.1/sql-syntax.xml 2006-03-31 15:12:39 UTC (rev 1713)
+++ trunk/refman-5.1/sql-syntax.xml 2006-04-01 10:02:42 UTC (rev 1714)
@@ -16801,7 +16801,7 @@
Execute at: NULL
Interval value: 10
Interval field: INTERVAL_SECOND
- Starts: 0000-00-00 00:00:00
+ Starts: 2006-02-09 10:41:23
Ends: 0000-00-00 00:00:00
Status: ENABLED
1 row in set (0.01 sec)
@@ -16927,6 +16927,14 @@
Note that the action statement is not shown in the output of
<literal>SHOW EVENTS</literal>.
</para>
+
+ <para>
+ <emphasis role="bold">Note</emphasis>: The values displayed
+ for <literal>Starts</literal> and <literal>Ends</literal>
+ (other than <literal>'0000-00-00 00:00:00'</literal>) are
+ always shown using Universal Time. For more information (and
+ an example), see <xref linkend="events-table"/>.
+ </para>
<para>
To see events for a different schema, you can use the
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1714 - trunk/refman-5.1 | jon | 1 Apr |
