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:[EMAIL PROTECTED] > webmail: mailto:[EMAIL PROTECTED] > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
