mysql时间戳类型_我应该在MySQL中使用日期时间或时间戳数据类型吗？

下面的示例显示了TIMESTAMP更改后，日期类型更改了值。time-zone to 'america/new_york'哪里DATETIME没有变化。

mysql> show variables like '%time_zone%';

+------------------+---------------------+

| Variable_name    | Value               |

+------------------+---------------------+

| system_time_zone | India Standard Time |

| time_zone        | Asia/Calcutta       |

+------------------+---------------------+

mysql> create table datedemo(

-> mydatetime datetime,

-> mytimestamp timestamp

-> );

mysql> insert into datedemo values ((now()),(now()));

mysql> select * from datedemo;

+---------------------+---------------------+

| mydatetime          | mytimestamp         |

+---------------------+---------------------+

| 2011-08-21 14:11:09 | 2011-08-21 14:11:09 |

+---------------------+---------------------+

mysql> set time_zone="america/new_york";

mysql> select * from datedemo;

+---------------------+---------------------+

| mydatetime          | mytimestamp         |

+---------------------+---------------------+

| 2011-08-21 14:11:09 | 2011-08-21 04:41:09 |

+---------------------+---------------------+

我把我的答案转换成文章让更多的人觉得这很有用，