如何转换mysql时间 [英] How to convert mysql time
本文介绍了如何转换mysql时间的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在mysql中的时间是hh:mm:ss
的形式,我该如何将其转换为12小时,并删除秒,因为它们都是00。
My time in mysql is in the form hh:mm:ss How can I convert that to 12 hour time and also remove the seconds, because they are all 00.
ex:
14:30:00
mysql
$finalresult = mysql_query("SELECT * FROM events WHERE clubID IN (" . implode(',', $clubIDs) . ") ORDER BY date ASC, TIME(startTime) ASC");
while($finalrow = mysql_fetch_assoc($finalresult)) {
$originaltime = $finalrow['startTime'];
$newtime = TIME_FORMAT($originaltime, '%h:%i %p');
}
推荐答案
使用< a href = http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_time-format rel = nofollow> TIME_FORMAT :
SELECT TIME_FORMAT('14:30:00', '%h:%i %p'); /* 02:30 PM */
更改您的PHP就是这样:
Change your PHP to something like this:
$finalresult = mysql_query("SELECT Field1, Field2, TIME_FORMAT(DateField, '%h:%i %p') AS TheTime FROM events WHERE clubID IN (" . implode(',', $clubIDs) . ") ORDER BY date ASC, TIME(startTime) ASC");
这涉及摆脱 *
并指定每个字段。
This involves getting rid of *
and specifying each field you want.
这篇关于如何转换mysql时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文