Page 1 of 1

Mysql Date help?

Posted: Tue Feb 16, 2010 6:56 am
by adilmarwat2004
I am using mysql.

I have the problem that I have created the table name "act" contains 3 fields
id(int), item(char), date(date)

When i generate the query to display all information in table, the date field shows
date like that 01/20/2010.
I want to set the format for date like 20/01/2010 every time when i use the query.

How it is possible. please help me.

Adil

Re: Mysql Date help?

Posted: Tue Feb 16, 2010 7:03 am
by Eran