Date format like day/month/year in mysql

[Anon]

Hi, how do i change the date format in mysql like '00-00-0000' instead of '0000-00-00'

I have a table including the following things

end date NOT NULL default '0000-00-00',

And I got a input box for entering date in a form. I want to insert and retriev date as day-month-year format(00-00-0000).

Anyone can help me thanks

[[deleted]]

You can use MySQL's DATE_FORMAT() function to re-format the date when you select it.

As fo the insert, you'll have to change the format in PHP before inserting it intp the database.

Check the mysql manual.

[Anon]

Thanks for ur reply. But how do i use it in this query

$query = "SELECT jcode,start,end,title,description,location,posted ,region from job,location, region
where
location.id=region.id
AND
job.fk_region=region.id order by jcode ";

Here is posted is the current date(And it inserted automatically because i use now() function to insert current date.) and start and end date will get from the form.

is there any code that formate date like this day-month-year before entering the values into table.

THanks again .. I am newbie

netmastan

[[deleted]]

did you read the manual pages?