[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-developers] parse date in php and mysql



> 
> I need a little help if anyone knows php and mysql.
> I have a query that returns date in an array in the format yyyy-mm-dd. I 
> need to change it to dd-mm-yyyy. Can anyone help?
> 
> This is why the date is in
> <?= $results[2] ?>
> 

You could try this:

	list( $year, $month, $day ) = split( '[/.-]', $results[2] );
	$results[2] = "$day/$month/$year";

--
Steve Cooke
Web Development Officer
Manchester Metropolitan University
Hollings Campus
Old Hall Lane, Manchester
M14 6HR