Author: paul
Date: 2006-10-30 19:24:15 +0100 (Mon, 30 Oct 2006)
New Revision: 3801
Log:
r15006@polar: paul | 2006-10-30 11:49:12 -0600
Lower end of TIMESTAMP data type is 1970-01-01 00:00:01,
not 1970-01-01 00:00:00. (Bug#22276)
Modified:
trunk/refman-4.1/connector-net.xml
trunk/refman-4.1/data-types.xml
trunk/refman-5.0/connector-net.xml
trunk/refman-5.0/data-types.xml
trunk/refman-5.1/connector-net.xml
trunk/refman-5.1/data-types.xml
trunk/refman-common/what-is.en.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:15004
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:11409
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:10957
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:15006
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:11409
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:10957
Modified: trunk/refman-4.1/connector-net.xml
===================================================================
--- trunk/refman-4.1/connector-net.xml 2006-10-30 17:11:16 UTC (rev 3800)
+++ trunk/refman-4.1/connector-net.xml 2006-10-30 18:24:15 UTC (rev 3801)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 784 bytes
@@ -10549,7 +10549,7 @@
</row>
<row>
<entry>Timestamp</entry>
- <entry>A timestamp. The range is '1970-01-01 00:00:00' to sometime in the year
+ <entry>A timestamp. The range is '1970-01-01 00:00:01' to sometime in the year
2037</entry>
</row>
<row>
Modified: trunk/refman-4.1/data-types.xml
===================================================================
--- trunk/refman-4.1/data-types.xml 2006-10-30 17:11:16 UTC (rev 3800)
+++ trunk/refman-4.1/data-types.xml 2006-10-30 18:24:15 UTC (rev 3801)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 2; 1114 bytes
@@ -1057,8 +1057,16 @@
<para>
A timestamp. The range is <literal>'1970-01-01
- 00:00:00'</literal> to partway through the year
- <literal>2037</literal>.
+ 00:00:01'</literal> UTC to partway through the year
+ <literal>2037</literal>. <literal>TIMESTAMP</literal> values
+ are stored as the number of seconds since the epoch
+ (<literal>'1970-01-01 00:00:00'</literal> UTC). A
+ <literal>TIMESTAMP</literal> cannot represent the value
+ <literal>'1970-01-01 00:00:00'</literal> because that is
+ equivalent to 0 seconds from the epoch and the value 0 is
+ reserved for representing <literal>'0000-00-00
+ 00:00:00'</literal>, the <quote>zero</quote>
+ <literal>TIMESTAMP</literal> value.
</para>
<para>
Modified: trunk/refman-5.0/connector-net.xml
===================================================================
--- trunk/refman-5.0/connector-net.xml 2006-10-30 17:11:16 UTC (rev 3800)
+++ trunk/refman-5.0/connector-net.xml 2006-10-30 18:24:15 UTC (rev 3801)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 784 bytes
@@ -10548,7 +10548,7 @@
</row>
<row>
<entry>Timestamp</entry>
- <entry>A timestamp. The range is '1970-01-01 00:00:00' to sometime in the year
+ <entry>A timestamp. The range is '1970-01-01 00:00:01' to sometime in the year
2037</entry>
</row>
<row>
Modified: trunk/refman-5.0/data-types.xml
===================================================================
--- trunk/refman-5.0/data-types.xml 2006-10-30 17:11:16 UTC (rev 3800)
+++ trunk/refman-5.0/data-types.xml 2006-10-30 18:24:15 UTC (rev 3801)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 2; 1114 bytes
@@ -1100,8 +1100,16 @@
<para>
A timestamp. The range is <literal>'1970-01-01
- 00:00:00'</literal> to partway through the year
- <literal>2037</literal>.
+ 00:00:01'</literal> UTC to partway through the year
+ <literal>2037</literal>. <literal>TIMESTAMP</literal> values
+ are stored as the number of seconds since the epoch
+ (<literal>'1970-01-01 00:00:00'</literal> UTC). A
+ <literal>TIMESTAMP</literal> cannot represent the value
+ <literal>'1970-01-01 00:00:00'</literal> because that is
+ equivalent to 0 seconds from the epoch and the value 0 is
+ reserved for representing <literal>'0000-00-00
+ 00:00:00'</literal>, the <quote>zero</quote>
+ <literal>TIMESTAMP</literal> value.
</para>
<para>
Modified: trunk/refman-5.1/connector-net.xml
===================================================================
--- trunk/refman-5.1/connector-net.xml 2006-10-30 17:11:16 UTC (rev 3800)
+++ trunk/refman-5.1/connector-net.xml 2006-10-30 18:24:15 UTC (rev 3801)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 784 bytes
@@ -10548,7 +10548,7 @@
</row>
<row>
<entry>Timestamp</entry>
- <entry>A timestamp. The range is '1970-01-01 00:00:00' to sometime in the year
+ <entry>A timestamp. The range is '1970-01-01 00:00:01' to sometime in the year
2037</entry>
</row>
<row>
Modified: trunk/refman-5.1/data-types.xml
===================================================================
--- trunk/refman-5.1/data-types.xml 2006-10-30 17:11:16 UTC (rev 3800)
+++ trunk/refman-5.1/data-types.xml 2006-10-30 18:24:15 UTC (rev 3801)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 2; 1114 bytes
@@ -1044,8 +1044,16 @@
<para>
A timestamp. The range is <literal>'1970-01-01
- 00:00:00'</literal> to partway through the year
- <literal>2037</literal>.
+ 00:00:01'</literal> UTC to partway through the year
+ <literal>2037</literal>. <literal>TIMESTAMP</literal> values
+ are stored as the number of seconds since the epoch
+ (<literal>'1970-01-01 00:00:00'</literal> UTC). A
+ <literal>TIMESTAMP</literal> cannot represent the value
+ <literal>'1970-01-01 00:00:00'</literal> because that is
+ equivalent to 0 seconds from the epoch and the value 0 is
+ reserved for representing <literal>'0000-00-00
+ 00:00:00'</literal>, the <quote>zero</quote>
+ <literal>TIMESTAMP</literal> value.
</para>
<para>
Modified: trunk/refman-common/what-is.en.xml
===================================================================
--- trunk/refman-common/what-is.en.xml 2006-10-30 17:11:16 UTC (rev 3800)
+++ trunk/refman-common/what-is.en.xml 2006-10-30 18:24:15 UTC (rev 3801)
Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 814 bytes
@@ -1119,7 +1119,7 @@
<literal>9999</literal>) exceed the <literal>TIMESTAMP</literal>
maximum. The <literal>TIMESTAMP</literal> data type, which is used
to store the current time, supports values that range from
- <literal>'1970-01-01 00:00:00'</literal> to <literal>'2030-01-01
+ <literal>'1970-01-01 00:00:01'</literal> to <literal>'2030-01-01
00:00:00'</literal> on 32-bit machines (signed value). On 64-bit
machines, <literal>TIMESTAMP</literal> handles values up to
<literal>2106</literal> (unsigned value).
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3801 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-common | paul | 30 Oct |
