如何从mysql日期中提取年,月,日,小时,分钟,秒? [英] How extract years, months, days, hours, minutes, seconds from a mysql date?
本文介绍了如何从mysql日期中提取年,月,日,小时,分钟,秒?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在我的mysql数据库中,我有这样的日期:2011-01-06 09:39:114525
In my mysql database I have dates like this: 2011-01-06 09:39:114525
我需要分别从中提取年,月,日,小时,分钟,秒.
and I need to extraxt separately years, months, days, hours, minutes, seconds from it.
所以我需要从上面的例子中提取出来:
So I need to extract from above example:
2011
01
06
09
39
11
我该怎么办?
推荐答案
在MySQL中,只需执行MONTH(date)
,YEAR(date)
等.在PHP中,您可以执行date('g', strtotime($datefromsql))
以获得例如12-小时格式,从日期开始为小时.
In MySQL, just do MONTH(date)
, YEAR(date)
, etc. In PHP, you can do date('g', strtotime($datefromsql))
to get, for example, the 12-hour format hour from the date.
因此在上面的示例中,您可以
So in your above example, you could either do
SELECT YEAR(date),
MONTH(date),
DAYOFMONTH(date),
HOUR(date),
MINUTE(date),
SECOND(date)
或在PHP中,
$time = strtotime($datefromsql);
echo date('Y', $time);
echo date('m', $time);
echo date('d', $time);
echo date('h', $time);
echo date('i', $time);
echo date('s', $time);
这篇关于如何从mysql日期中提取年,月,日,小时,分钟,秒?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文