Time Conversion
Sat, 02/26/2011 - 23:40
Hi Everyone,
The default format returned form mysql is coming out as Feb 27 2011.. I need to convert this format to 27-Feb-2011 or 27-02-2011. Trouble is, I am using this statement,
$date = $query->Date; //Date is the column in table
now $date does not have any date time conversion methods, so I cannot use
$date->DateFormat = "dd mm yyyy";
any ideas??
try
$date = DateTime::createFromFormat('M j Y',$query->Date);
or in MySQL
SELECT DATE_FORMAT(date,'%d-%e-%Y') ...
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
after killing almost a days time on this..
foreach(....as $mixrow)
{
$date = $mixrow->Date;
$date = date('d-M-Y', strtotime($date));
}
seems to work for me!! Thanks for helping out Mile!
You could also use something like:
$date = $query->Date->qFormat("DD MM YYYY");Assuming $query->Date is of type "date" in your database.