Hi all, I was wondering how I can display a date in this format 'DD/MM/YY' As when I do a select statement and display the date I get it in this format 'DD-MM-YYY 00:00:00' Which is kind of annoying. I am using mySQL and also PHP. Thanks in advance. Sam Rose --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php