It's not annoying if that's the format you require...
Try the DATE_FORMAT() function like so:
select DATE_FORMAT(datecolumn,"%d/%m/%y") from tbl_name;
Please see the manual:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
On Wed, 24 Jan 2001, Sam wrote:
> 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
