Mysql Date help?
Posted: Tue Feb 16, 2010 6:56 am
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
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