使用PHP和MySQL存储当前时间的推荐方法是什么？-What'stherecommendedwaytostorecurrenttimeusingPHPandMySQL?

18  

It is recommended to use mysql timestamp (YYYY-MM-DD HH:MM:SS) field type to store time and date variables in mysql.

建议使用mysql时间戳（YYYY-MM-DD HH：MM：SS）字段类型在mysql中存储时间和日期变量。

$sDate = date("Y-m-d H:i:s"); // 2015-04-07 07:12:51
mysql_query("insert into `table_name` set `created_on` = '$sDate'");

It gives you ability to use mysql functions to compare dates, calculate time differences and so, directly in your mysql query.

它使您能够使用mysql函数来比较日期，计算时间差等，直接在您的mysql查询中。

Also you can always retrieve the timestamp using strtotime() function.

您也可以使用strtotime（）函数检索时间戳。

$result = mysql_query("select `created_on` from `table_name`");
$row = mysql_fetch_row($result);
$iTimestamp = strtotime($row[0]); // 1428390771

3  

I just use the TIMESTAMP value type in MySQL, and let MySQL use its own CURRENT_TIMESTAMP.

我只是在MySQL中使用TIMESTAMP值类型，让MySQL使用自己的CURRENT_TIMESTAMP。

1  

Well, you can turn a MySQL TIMESTAMP field into a PHP Time() value by using strtotime()

那么，您可以使用strtotime（）将MySQL TIMESTAMP字段转换为PHP Time（）值

Then you just have to make a function that correctly turns a PHP Time() value into a MySQL TIMESTAMP value.

然后你只需要创建一个正确将PHP Time（）值转换为MySQL TIMESTAMP值的函数。

0  

The format used by MySQL doesn't need to match the format used by PHP. Choose the best on either side. Databases have date data types for a reason; in MySQL you can choose from these:

MySQL使用的格式不需要与PHP使用的格式匹配。选择最好的两边。出于某种原因，数据库具有日期数据类型;在MySQL中，您可以选择以下内容：

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html

In PHP, you basically have three options:

在PHP中，您基本上有三个选项：

• Good old timestamps are easy to handle and you can use them in your MySQL queries —see FROM_UNIXTIME() and UNIX_TIMESTAMP()— but they have serious range issues (you can't rely on them for pre-1970 dates, so they are unsuitable for birthdays).

  好的旧时间戳很容易处理，您可以在MySQL查询中使用它们 - 查看FROM_UNIXTIME（）和UNIX_TIMESTAMP（） - 但是它们存在严重的范围问题（您不能在1970年之前的日期依赖它们，因此它们不适合为了生日）。

• DateTime objects are powerful and builtin, have no range issues and support time zones. However, they are sometimes not very comfortable to use since they seem to lack some important methods.

  DateTime对象功能强大且内置，没有范围问题并支持时区。然而，它们有时使用起来不太舒服，因为它们似乎缺乏一些重要的方法。

• You can use a custom date object (third-party or your own DateTime based).

  您可以使用自定义日期对象（第三方或您自己的基于DateTime）。

0  

Storing it as int is more logical. You save the row format of date, using which you can later extract other format and more data .. I also save it as int.

将其存储为int更合乎逻辑。您保存日期的行格式，使用它可以稍后提取其他格式和更多数据..我也将其保存为int。

Edit: For(Uni-TimeZone) application int is the fastest way and PHP has great time conversion tools.

编辑：对于（Uni-TimeZone）应用程序int是最快的方式，PHP有很棒的时间转换工具。