[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [cobalt-developers] parse date in php and mysql
- Subject: Re: [cobalt-developers] parse date in php and mysql
- From: "Stephen Cooke" <s.cooke@xxxxxxxxx>
- Date: Thu Apr 3 23:48:01 2003
- Organization: Manchester Metropolitan University
- List-id: Discussion Forum for developers on Sun Cobalt Networks products <cobalt-developers.list.cobalt.com>
>
> 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