[RESOLVED] SELECT - DATE_FORMAT() query

meetn2veg

I'm trying to get a "DATE_FORMAT(arrive, '%d-%M-%y' ) as arr" select param to work correctly, but can't!

Although I'm running Apache/2.0.59 (Win32) PHP/5.2.5, my host runs PHP/4.4.7 - but it shouldn't make a dfference. I have not checked this on my host server as yet.

The output I'm getting (on localhost) is not the desired one! All I'd like is for the SELECT query to output the month as a 3 letter abbrev. (ie: 28-Feb-09) as is documented it should.

However, what I'm seeing is %M outputs the full month name (ie:28-February-09), and %F is not recognised at all (28-%F-09).

Is there perhaps something in the php.ini file which needs changing? Or something else???

Comments most welcome by anyone who could 'enlighten' me :-)

Richard.

bradgrafelman

meetn2veg wrote:
All I'd like is for the SELECT query to output the month as a 3 letter abbrev. (ie: 28-Feb-09) as is documented it should.

As is documented? In the documentation, I see '%M' described as: "Month name (January..December)", '%F' isn't even in the list of valid strings, and '%b' listed as " Abbreviated month name (Jan..Dec)".

meetn2veg

Thank you for your prompt reply! I knew it would have been something simple.

FYI - the documentation I was referring to was O'Reilley's Platypus - Web Database Applications, 1st Ed 2002; on page 87.

Why didn't it occur to me that they could have been wron?!?

:-)
Thanks.

bradgrafelman

Glad I could help. Don't forget to mark this thread resolved (using the link under "Thread Tools").

Also, as a sidenote; look at the copyright/edition number you just posted. That's the first edition published, around seven years ago. In the day and age where the top-of-the-line computer is obsoleted in one way or the other within at most 6 months, seven years is quite ancient. :p

meetn2veg

I'm already looking for a museum where I could donate my Platypus O'Reilleus, but no takers at the mo!