仅从日期时间字段（mysql）中提取日期并将其分配给 php 变量
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14020090/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Extracting only date from datetime field (mysql) and assigning it to php variable
提问by user1114409
I am unable to assign only date to a php variable from datetimefield of a MySQL table. I am using PHP 4, I know how to do it in PHP 5.
我无法仅将日期分配给datetimeMySQL 表字段中的php 变量。我正在使用PHP 4，我知道如何在 PHP 5 中做到这一点。
Can someone help as to what is missing from the below php code.
有人可以帮助了解以下 php 代码中缺少的内容。
$dc = mysql_query("SELECT * FROM INVHDR WHERE Invdate BETWEEN '2011-04-01' AND '2012-03-31'");
while ($dc2 = mysql_fetch_assoc($dc)) {
$invno = $dc2['Invno']; // Here Invno is a datetime field type
$invdat3 = $dc2['Invdate'];
$date_array = explode("-", $invdat3);
$invdat = sprintf('%02d/%02d/%4d', $date_array[2], $date_array[1], $date_array[0]);
}
回答by Salman A
回答by Your Common Sense
There is a link I find extremely useful when it comes to date manipulations: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
我发现在日期操作方面有一个非常有用的链接：http: //dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
one can easily find the solution there:
人们可以很容易地在那里找到解决方案：
SELECT *, DATE(Invdate) as Inv_date ...
回答by Peter Krejci
Do it directly in MySQL:
直接在 MySQL 中执行：
select DATE_FORMAT('2012-12-24 12:13:14', '%Y/%m/%d')
So your query will look like this:
因此，您的查询将如下所示：
SELECT DATE_FORMAT(Invdate, '%Y/%m/%d') FROM INVHDR WHERE Invdate BETWEEN '$startdat' AND '$enddat'
