On Wed, Apr 06, 2005 at 12:06:37PM +0200, Hans Bernard wrote: > 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
Use date_format(...., "%d-%b-%Y %H:%m") in your SELECT? bye, -christian- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]