[PHP] Re: format date field

SELECT DATE_FORMAT('open', '%m-%d-%Y') FROM your_table_name; -- itoctopus - http://www.itoctopus.com Mike Ryan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I am reading in a date field from a mysql database the field on the screen shows up as 2007-05-01 on the screen I would like

[PHP] Re: Format Date

Dark Rotter wrote: Hi, When i print a date, the format of this date is: 8 nov 2001 0:00 (print ($array[date])) but i need print this: 08/11/2001 how i print this ? try print date( 'd/m/Y', strtotime( $array['date'] ) ); HTH Erwin -- PHP General Mailing List (http://www.php.net/)