Extracting only date from datetime field (mysql) and assigning it to php variable

If you just want to display the date portion, you could use the DateTime class:

echo DateTime::createFromFormat("Y-m-d H:i:s", "2012-12-24 12:13:14")->format("d/m/Y");
// 24/12/2012

//Edited for double echo typo.

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

one can easily find the solution there:

SELECT *, DATE(Invdate) as Inv_date ...

Do it directly in 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'

Related