Hello, i need to have the time in this output. in MySQL database phpmyadmin always puts 0000-00-00
i need it to be like this 01-APR-2005 >> DD-MMM-YYYY the time needs to be like this 22:55 >> HH:MM can somebody help hans -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]