blocks|key|858388|text|一种更简单的方法是直接在MySQL查询中格式化日期，而不是PHP。见格式化。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|858389|如果您希望在PHP中这样做，那么您需要日期函数，但是您必须首先将数据库值转换为时间戳。|858390|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format|1|http://uk.php.net/date^0|Y|3|0|0|J|2|1|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

An easier way would be to format the date directly in the MySQL query, instead of PHP. See the <a href="http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format" rel="noreferrer">MySQL manual entry for DATE_FORMAT</a>.

If you'd rather do it in PHP, then you need the <a href="http://uk.php.net/date" rel="noreferrer">date</a> function, but you'll have to convert your database value into a timestamp first.

blocks|key|858392|text|使用日期函数：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|858393|<?php
++++echo+date("m/d/y+g:i+(A)",+$DB_Date_Field);
?>|code-block|syntax|javascript|858394|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/date^0|2|2|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Use the <a href="http://www.php.net/date" rel="noreferrer">date</a> function:

<pre><code>&lt;?php
 echo date("m/d/y g:i (A)", $DB_Date_Field);
?&gt;
</code></pre>

blocks|key|1182220|text|若要将从MySQL检索的日期转换为所请求的格式(mm/dd/yy+H:M+(AM/PM))：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1182221|//+$datetime+is+something+like:+2014-01-31+13:05:59
$time+=+strtotime($datetimeFromMysql);
$myFormatForView+=+date("m/d/y+g:i+A",+$time);
//+$myFormatForView+is+something+like:+01/31/14+1:05+PM|code-block|syntax|javascript|1182222|请参考PHP日期格式选项来调整格式。|1182223|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.date.php#refsect1-function.date-parameters^0|O|K|0|0|3|9|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

To convert a date retrieved from MySQL into the format requested (<code>mm/dd/yy H:M (AM/PM)</code>):

<pre><code>// $datetime is something like: 2014-01-31 13:05:59
$time = strtotime($datetimeFromMysql);
$myFormatForView = date("m/d/y g:i A", $time);
// $myFormatForView is something like: 01/31/14 1:05 PM
</code></pre>

Refer to the <a href="http://php.net/manual/en/function.date.php#refsect1-function.date-parameters" rel="noreferrer">PHP date formatting options</a> to adjust the format.

blocks|key|1182265|text|您还可以让查询以Unix时间戳的形式返回时间。这将消除调用strtotime()的需要，并使PHP方面的工作变得不那么密集.|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1182266|select++UNIX_TIMESTAMP(timsstamp)+as+unixtime+from+the_table+where+id+=+1234;|code-block|syntax|javascript|1182267|然后，在PHP中，只需使用date()函数来格式化它，不管您喜欢哪种方式。|1182268|<?php
++echo+date('l+jS+\of+F+Y+h:i:s+A',+$row->unixtime);
?>|1182269|或|1182270|<?php
++echo+date('F+j,+Y,+g:i+a',+$row->unixtime);
?>|1182271|我喜欢这种方法，而不是使用MySQL的DATE_FORMAT函数，因为它允许您重用相同的查询来获取数据，并允许您在PHP中更改格式。|1182272|有两个不同的查询只是为了改变用户界面中日期的方式，这是很烦人的。|1182273|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/MySQL^0|T|B|0|0|D|6|0|0|0|0|J|B|D|5|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@$9|15|A|16|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|17|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|1B|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|1C|8|@]|D|@]|E|$]]|$1|Q|3|R|5|H|7|1D|8|@]|D|@]|E|$I|J]]|$1|S|3|T|5|6|7|1E|8|@$9|1F|A|1G|B|C]]|D|@$9|1H|A|1I|1|1J]]|E|$]]|$1|U|3|V|5|6|7|1K|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|1L|8|@]|D|@]|E|$]]]|X|$Y|$5|Z|10|11|E|$12|13]]]]

You can also have your query return the time as a Unix timestamp. That would get rid of the need to call <code>strtotime()</code> and make things a bit less intensive on the PHP side...

<pre><code>select UNIX_TIMESTAMP(timsstamp) as unixtime from the_table where id = 1234;
</code></pre>

Then in PHP just use the <code>date()</code> function to format it whichever way you'd like.

<pre><code>&lt;?php
 echo date('l jS \of F Y h:i:s A', $row-&gt;unixtime);
?&gt;
</code></pre>

or 

<pre><code>&lt;?php
 echo date('F j, Y, g:i a', $row-&gt;unixtime);
?&gt;
</code></pre>

I like this approach as opposed to using <a href="http://en.wikipedia.org/wiki/MySQL" rel="nofollow noreferrer">MySQL</a>'s <code>DATE_FORMAT</code> function, because it allows you to reuse the same query to grab the data and allows you to alter the formatting in PHP.

It's annoying to have two different queries just to change the way the date looks in the UI.

blocks|key|183340|text|如果您正在使用PHP+5，也可以尝试|type|unstyled|depth|inlineStyleRanges|entityRanges|data|183341|$oDate+=+new+DateTime($row->createdate);
$sDate+=+$oDate->format("Y-m-d+H:i:s");|code-block|syntax|javascript|183342|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you are using PHP 5, you can also try

<pre><code>$oDate = new DateTime($row-&gt;createdate);
$sDate = $oDate-&gt;format("Y-m-d H:i:s");
</code></pre>

blocks|key|183374|text|使用PHPVersion4.4.9和MySQL+5.0，这对我起了作用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|183375|$oDate+=+strtotime($row['PubDate']);
$sDate+=+date("m/d/y",$oDate);
echo+$sDate|code-block|syntax|javascript|183376|PubDate是MySQL中的列。|offset|length|style|CODE|183377|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/MySQL^0|0|0|0|7|8|5|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]]|9|@$I|Z|J|10|1|11]]|A|$]]|$1|M|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

Using PHP version 4.4.9 &amp; MySQL 5.0, this worked for me:

<pre><code>$oDate = strtotime($row['PubDate']);
$sDate = date("m/d/y",$oDate);
echo $sDate
</code></pre>

<code>PubDate</code> is the column in <a href="http://en.wikipedia.org/wiki/MySQL" rel="nofollow noreferrer">MySQL</a>.

blocks|key|183396|text|在Unix时间戳中没有返回的日期可能会有问题，所以这适用于我.|type|unstyled|depth|inlineStyleRanges|entityRanges|data|183397|return+date("F+j,+Y+g:i+a",+strtotime(substr($datestring,+0,+15)))|code-block|syntax|javascript|183398|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can have trouble with dates not returned in Unix Timestamp, so this works for me...

<pre><code>return date("F j, Y g:i a", strtotime(substr($datestring, 0, 15)))
</code></pre>

blocks|key|858484|text|如果您正在寻找将日期规范化为MySQL格式的方法，请使用以下方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|858485|$phpdate+=+strtotime(+$mysqldate+);
$mysqldate+=+date(+'Y-m-d+H:i:s',+$phpdate+);|code-block|syntax|javascript|858486|行$phpdate+=+strtotime(+$mysqldate+)接受一个字符串，并执行一系列试探，将该字符串转换为unix时间戳。|offset|length|style|CODE|858487|行$mysqldate+=+date(+'Y-m-d+H:i:s',+$phpdate+)使用时间戳和PHP的date函数将时间戳返回到MySQL的标准日期格式。|858488|(编辑备注：这个答案是因为一个原始的问题，用词混乱，而且谷歌的这个答案是有用的，即使它没有直接回答现在存在的问题)|BOLD|858489|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/^0|0|0|1|Y|0|1|18|1J|4|1J|4|0|0|1|4|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|10|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|11|8|@$I|12|J|13|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|14|8|@$I|15|J|16|K|L]|$I|17|J|18|K|L]]|9|@$I|19|J|1A|1|1B]]|A|$]]|$1|O|3|P|5|6|7|1C|8|@$I|1D|J|1E|K|Q]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]]]

If you're looking for a way to normalize a date into MySQL format, use the following

<pre><code>$phpdate = strtotime( $mysqldate );
$mysqldate = date( 'Y-m-d H:i:s', $phpdate );
</code></pre>

The line <code>$phpdate = strtotime( $mysqldate )</code> accepts a string and performs a series of heuristics to turn that string into a unix timestamp.

The line <code>$mysqldate = date( 'Y-m-d H:i:s', $phpdate )</code> uses that timestamp and PHP's <a href="http://php.net" rel="noreferrer"><code>date</code></a> function to turn that timestamp back into MySQL's standard date format.

(Editor Note: This answer is here because of an original question with confusing wording, and the general Google usefulness this answer provided even if it didnt' directly answer the question that now exists)

blocks|key|183460|text|这将格式化SQL查询中的字段：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|183461|SELECT+DATE_FORMAT(+`fieldname`+,+'%25d-%25m-%25Y'+)+FROM+tablename|code-block|syntax|javascript|183462|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This should format a field in an SQL query:

<pre><code>SELECT DATE_FORMAT( `fieldname` , '%d-%m-%Y' ) FROM tablename
</code></pre>

blocks|key|854286|text|忘掉一切。只需使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|854287|$date+=+date("Y-m-d+H:i:s",strtotime(str_replace('/','-',$date)))|code-block|syntax|javascript|854288|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Forget all. Just use:

<pre><code>$date = date("Y-m-d H:i:s",strtotime(str_replace('/','-',$date)))
</code></pre>

blocks|key|858506|text|$valid_date+=+date(+'m/d/y+g:i+A',+strtotime($date));|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|858507|参考：+http://php.net/manual/en/function.date.php|unstyled|offset|length|style|BOLD|858508|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.date.php^0|0|0|3|4|16|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|T|8|@$G|U|H|V|I|J]]|9|@$G|W|H|X|1|Y]]|A|$]]|$1|K|3|-4|5|F|7|Z|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

<pre><code>$valid_date = date( 'm/d/y g:i A', strtotime($date));
</code></pre>

Reference: <a href="http://php.net/manual/en/function.date.php" rel="noreferrer">http://php.net/manual/en/function.date.php</a>

blocks|key|854301|text|要正确格式化DateTime对象以便将其存储在MySQL中，请使用MySQL使用的标准化格式，即ISO+8601。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|854302|PHP从5.1.1版本开始将这种格式作为常量存储，我强烈建议使用它，而不是每次手动输入字符串。|854303|$dtNow+=+new+DateTime();
$mysqlDateTime+=+$dtNow->format(DateTime::ISO8601);|code-block|syntax|javascript|854304|这一点，以及其他PHP常量的列表可以在DateTime上找到。|854305|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/ISO_8601^0|6|8|1C|8|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|6|7|12|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|13|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|14|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

To correctly format a <code>DateTime</code> object in PHP for storing in MySQL use the standardised format that MySQL uses, which is <a href="http://en.wikipedia.org/wiki/ISO_8601" rel="noreferrer">ISO 8601</a>.

PHP has had this format stored as a constant since version 5.1.1, and I highly recommend using it rather than manually typing the string each time.

<pre><code>$dtNow = new DateTime();
$mysqlDateTime = $dtNow-&gt;format(DateTime::ISO8601);
</code></pre>

This, and a list of other PHP DateTime constants are available at <a href="http://php.net/manual/en/class.datetime.php#datetime.constants.types" rel="noreferrer">http://php.net/manual/en/class.datetime.php#datetime.constants.types</a>

blocks|key|1182490|text|$date+=+"'".date('Y-m-d+H:i:s',+strtotime(str_replace('-',+'/',+$_POST['date'])))."'";|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1182491|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$date = "'".date('Y-m-d H:i:s', strtotime(str_replace('-', '/', $_POST['date'])))."'";
</code></pre>

blocks|key|1182523|text|取决于您的MySQL日期时间配置。通常情况下：2011-12-31.07:55:13格式.这个非常简单的函数应该具有魔力：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1182524|function+datetime()
{
++++return+date(+'Y-m-d+H:i:s',+time());
}

echo+datetime();+//+display+example:+2011-12-31+07:55:13|code-block|syntax|javascript|1182525|或者更先进一点来匹配这个问题。|1182526|function+datetime($date_string+=+false)
{
++++if+(!$date_string)
++++{
++++++++$date_string+=+time();
++++}
++++return+date("Y-m-d+H:i:s",+strtotime($date_string));
}|1182527|entityMap^0|N|J|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

Depending on your MySQL datetime configuration. Typically: 2011-12-31 07:55:13 format. This very simple function should do the magic:

<pre><code>function datetime()
{
 return date( 'Y-m-d H:i:s', time());
}

echo datetime(); // display example: 2011-12-31 07:55:13
</code></pre>

Or a bit more advance to match the question.

<pre><code>function datetime($date_string = false)
{
 if (!$date_string)
 {
 $date_string = time();
 }
 return date("Y-m-d H:i:s", strtotime($date_string));
}
</code></pre>

blocks|key|1182536|text|这会成功的..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1182537|echo+date('m/d/y+H:i+(A)',strtotime($data_from_mysql));|code-block|syntax|javascript|1182538|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This will work...

<pre><code>echo date('m/d/y H:i (A)',strtotime($data_from_mysql));
</code></pre>

blocks|key|1182573|text|最后，PHP+5.3和更高版本的正确解决方案：(在示例中添加了可选的Timezone，如注释中提到的)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1182574|无时区：|1182575|$date+=+\DateTime::createFromFormat('Y-m-d+H:i:s',+$mysql_source_date);
echo+$date->format('m/d/y+h:i+a');|code-block|syntax|javascript|1182576|时区：|1182577|$date+=+\DateTime::createFromFormat('Y-m-d+H:i:s',+$mysql_source_date,+new+\DateTimeZone('UTC'));
$date->setTimezone(new+\DateTimeZone('Europe/Berlin'));
echo+$date->format('m/d/y+h:i+a');|1182578|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Finally the right solution for PHP 5.3 and above:
(added optional Timezone to the Example like mentioned in the comments)
without time zone:
<pre><code>$date = \DateTime::createFromFormat('Y-m-d H:i:s', $mysql_source_date);
echo $date-&gt;format('m/d/y h:i a');
</code></pre>
with time zone:
<pre><code>$date = \DateTime::createFromFormat('Y-m-d H:i:s', $mysql_source_date, new \DateTimeZone('UTC'));
$date-&gt;setTimezone(new \DateTimeZone('Europe/Berlin'));
echo $date-&gt;format('m/d/y h:i a');
</code></pre>

blocks|key|1182593|text|SELECT+
+DATE_FORMAT(demo.dateFrom,+'%25e.%25M.%25Y')+as+dateFrom,
+DATE_FORMAT(demo.dateUntil,+'%25e.%25M.%25Y')+as+dateUntil
FROM+demo|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1182594|如果您不想更改PHP代码中的每个函数，要显示预期的日期格式，请在源代码-数据库中更改它。|unstyled|1182595|将中的行命名为操作符非常重要，如上面的示例所示(+dateFrom，dateUntil)。您所写的名称是名称，行将在您的结果中被调用。|offset|length|style|BOLD|1182596|此示例的输出将是|1182597|月份中的一天，数字(0..31).Month+name+(January..December).Year，数字，四位数|1182598|例子:2015年8月5日|1182599|用选择的分隔符更改点，并检查格式(日期、格式)函数以获得更多的日期格式。|1182600|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format^0|0|0|1|6|0|0|0|0|E|9|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|13|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|14|8|@$I|15|J|16|K|L]]|9|@]|A|$]]|$1|M|3|N|5|F|7|17|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|18|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|19|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|1A|8|@]|9|@$I|1B|J|1C|1|1D]]|A|$]]|$1|U|3|-4|5|F|7|1E|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]]]

<pre><code>SELECT 
 DATE_FORMAT(demo.dateFrom, '%e.%M.%Y') as dateFrom,
 DATE_FORMAT(demo.dateUntil, '%e.%M.%Y') as dateUntil
FROM demo
</code></pre>

If you dont want to change every function in your PHP code, to show the expected date format, change it at the source - your database.

It is important to name the rows with the as operator as in the example above (as dateFrom, as dateUntil). The names you write there are the names, the rows will be called in your result.

The output of this example will be 

[Day of the month, numeric (0..31)].[Month name (January..December)].[Year, numeric, four digits]

Example: 5.August.2015

Change the dots with the separator of choice and check the <a href="http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format" rel="noreferrer">DATE_FORMAT(date,format)</a> function for more date formats.

blocks|key|858573|text|我建议的方法如下所示。首先，从mysql格式的字符串中创建一个基本的datetime对象；然后以您喜欢的方式格式化它。幸运的是，mysql与is+8601兼容，因此代码本身看起来非常简单和优雅。但是请记住，datetime列没有时区信息，所以您需要适当地转换它。。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|858574|下面是代码：|858575|(new+ISO8601Formatted(
++++new+FromISO8601('2038-01-19+11:14:07'),
++++'m/d/Y+h:iA'
))
++++->value();|code-block|syntax|javascript|858576|它输出01/19/2038+11:14AM+--希望能满足您的期望。|858577|此示例使用meringue库。如果你喜欢的话你可以再看一看。|858578|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/2505681/timezone-conversion-in-php/61840217#61840217|1|https://meringue.readthedocs.io/en/latest/quick_start.html^0|2V|8|3D|A|0|0|0|0|3|I|0|P|4|1|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@$9|13|A|14|1|15]]|E|$]]|$1|F|3|G|5|6|7|16|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|17|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1B|8|@]|D|@$9|1C|A|1D|1|1E]]|E|$]]|$1|Q|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]|Y|$5|T|U|V|E|$W|Z]]]]

The approach I suggest works like the following. First, you create a basic datetime object from a mysql-formatted string; and then you format it the way you like. Luckily, mysql datetime is ISO8601-compliant, so the code itself could look quite simple and elegant. Keep in mind though that <code>datetime</code> column doesn't have a timezone information, so <a href="https://stackoverflow.com/questions/2505681/timezone-conversion-in-php/61840217#61840217">you need to convert it appropriately</a>.

Here's the code:

<pre><code>(new ISO8601Formatted(
 new FromISO8601('2038-01-19 11:14:07'),
 'm/d/Y h:iA'
))
 -&gt;value();
</code></pre>

It outputs <code>01/19/2038 11:14AM</code> -- hopefully what you expect.

This example uses meringue library. You can <a href="https://meringue.readthedocs.io/en/latest/quick_start.html" rel="nofollow noreferrer">check out some more of it</a> if you fancy.

blocks|key|1182691|text|直接输出，例如以德文格式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1182692|++echo(date('d.m.Y+H:i:s',+strtotime($row["date_added"])));|code-block|syntax|javascript|1182693|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Direct output e.g. in German format:
<pre><code> echo(date('d.m.Y H:i:s', strtotime($row[&quot;date_added&quot;])));
</code></pre>

I have a <code>datetime</code> column in MySQL. 

How can I convert it to the display as mm/dd/yy H:M (AM/PM) using PHP?

Convert from MySQL datetime to another format with PHP

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我在MySQL中有一个MySQL列。如何使用PHP将其转换为mm/dd/yy :m (AM/PM)？

问用PHP从MySQL日期时间转换为另一种格式
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用PHP从MySQL日期时间转换为另一种格式EN