Posted by Rik on 08/24/07 01:17

On Fri, 24 Aug 2007 01:23:53 +0200, MattMika <mattmika@hotmail.com> wrote:

> 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.
>

Is it MySQL? If so:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format
--
Rik Wasmus

• Next in forum: Re: Unique Image Query
• Prev 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.
• Thread view: Re: Format datetime with query?

[Reply to this message]