[RESOLVED] Format timestamp into "d,m,Y"

dcjones

Hi,

I have mastered the timestamp field type in MySQL which has made life a lot easier thanks to recommendations from member of this forum, many thanks for that.

I have been trying to format the date output to screen and I have been going round bend with it.

If I format the timestamp field in my SQL query like

SELECT *, DATE_FORMAT(f_date, '%Y/%m/%d') as date2

This works fine to a point, it will output, example: 2007-04-15, but I would like to to output like "15-04.2007" thats "day, month and year"

Can this be done using my SQL query, I have tried reversing the date format

SELECT *, DATE_FORMAT(f_date, '%d/%m/%Y) as date2

but the results are not as expected.

Can anyone please advise.

bradgrafelman

dcjones wrote:
it will output, example: 2007-04-15

Really? It shouldn't. What it SHOULD output is 2007/04/15. Why? Because that's how you formatted the string... %Y/%m/%d.

dcjones wrote:
but I would like to to output like "15-04.2007"

I don't quite understand the mix of a hypen and a period, but nonetheless this is certainly possible; all you do is modify the second parameter of the DATE_FORMAT() comand to suit your needs.

dcjones

Your right it was me not looking at what i was doing, sorry.