Current_Date

[`Karl]

I have a table to record when a record has been updated, see below.

 

`modifiedon` = current_date

 

However, when I produce the output, the format is YYYY/MM/DD, I want the output to be DD/MM/YYYY, which would be the best way to do this?

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

[`Karl]

I've had a read, and a mess around, but I still can't figure out how to do it.

[`Karl]

Can anyone help?

[PHPro]

SELECT DATE_FORMAT('2009-11-11', '%D %M %Y');

 

Try that and just mess around and figure it out. Try with more detailed question next time.

[`Karl]

What more can I add?

 

I'm using the Current_Date to add the date to the database and I want the output to be different, which is what I put in my question.

 

The question isn't detailed, and I tried what you posted before you even suggested it. Yet it makes no difference.

[Daniel0]

Then perhaps you should try posting the queries you've attempted to use and don't work. We can't really tell from "I've tried a number of different things".

 

"Doesn't work" isn't very descriptive either. It can mean many things such as 1) unexpected result, 2) no output, 3) errors, etc. You should always tell what result you expect, what result you get and any errors that pop up.