the function you need is DATE_FORMAT()
select event, DATE_FORMAT(my_time,'%d-%m-%Y) as mytime From mytable; mytime will be in the form dd-mm-yyyy, the %d specifier will give you the prefferred output -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
