Hi Tim!
You could do something like this:
$sqlstr = "select date_format(EventStartDate, '%M %D %Y') as mydate, ....(rest of your
SQL string here)" ;
$result = mysql("mydb", $sqlstr, $connect) ;
$myformatteddate = mysql_result($result, 0, 'mydate') ;
This should do it for you :) HTH
--Sam
On Tue, 29 May 2001 14:39:51 -0500 Tim Thorburn <[EMAIL PROTECTED]> wrote:
>Hi,
>
>I've setup a database to keep track of various events. Now I'm working on
>displaying these events on the screen through a web browser. I've got all
>the crucial information displaying - now its time for a little fine tuning.
>
>All the dates in my database are ISO format, so YYYY-MM-DD, I'd like to
>display them in a more user friendly format. For example, there is an
>event taking place this Wednesday, in ISO 2001-05-30 - I'd like it to
>display as May 30th, 2001.
>
>Through the command line, I know I do this by typing:
>select DATE_FORMAT(EventStartDate, '%M %D %Y');
>
>My question is how would i get this information to display via PHP?
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php