Mysql Date help?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
adilmarwat2004
Forum Commoner
Posts: 44
Joined: Fri Sep 04, 2009 11:28 pm

Mysql Date help?

Post 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
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Mysql Date help?

Post by Eran »

Post Reply