[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 wou

[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://ww