Posted by MattMika on 08/23/07 23:23

Is there a way to format datetime (2007-08-23 07:00:00) into something
like Aug. 23rd, 2007 7am within a query?

A little explanation. This is an events table that is queried from a
PHP class triggered from flash via AMFPHP, the mysql result is then
sent back to Flash.

I plan of having php forms to add, edit and delete entries in this
table so was thinking I could just have a datetime field and a
format_date field that would get a formatted version of the datetime
when inserted or updated.

Theres got to be a better solution to avoid having two date fields in
my db. Any suggestions?

TIA
Matt Mika

• Next in forum: M.A.R.L.B.O.R.O...C.I.G.A.R.E.T.T.E.S......She may love urban books to the open lean rain, whilst Pete superbly hates them too.
• Prev in forum: Re: href in mysql databse
• Thread view: Format datetime with query?

[Reply to this message]