Re: convert yyyy/mm/dd to mm/dd/yyyy, how?

MySQL has plenty of functions to return dates to you in any format you specify. Please read http://mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions and pay special attention to the DATE_FORMAT() function. -Rasmus On Sun, 13 Jan 2002, Sander Peters wrote: > Hello everybody, > > convert yyyy/mm/dd to mm/dd/yyyy, how? > > MYSQL does everything in yyyy/mm/dd. > I live in the Netherlands and we are use to the format dd/mm/yyyy. > > What's the best way to display it as mm/dd/yyyy in a table on a query? > > My first idea whas to split the date up in vars in php and then print > the vars in the way I like it > Is this a bad idea? Or are there better sollutions? > > Thanx in advance for answering! > > > > -- > Met vriendelijke groet / With Greetings, > > Sander Peters > > site: http://www.visionnet.nl/ > email: mailto:s.peters@visionnet.nl > webmail: mailto:sanderpeters@yahoo.com > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >