On Saturday 27 April 2002 14:43, Ananth Rajaraman wrote: > Hi all, > I'm trying to query a date field from mySQL and > display in a differnet format. > > the mysql date is in the format YYYY-MM-DD and I want > to convert it to DD-MM-YYYY > > how do I do that?
Use mysql's extensive date formatting functions. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* "Remember kids, if there's a loaded gun in the room, be sure that you're the one holding it" -- Captain Combat */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
