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 wonde
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
