Posted by Captain Paralytic on 04/27/07 11:07

On 27 Apr, 06:58, Ron <nom...@cox.net> wrote:
> Hi everyone,
>
> I'd like to use a timestamp on a site and made a table I update with
> PHPadmin. Pretty cool except my abilities are a bit limited on echoing
> out this with anthing beyond what is stored in the field. Eerything is
> stored and echoed out as YYYY-MM-DD HH:MM:SS and i can make that
> happen.
> In Excel I could tear this apart into separate columns and I know how
> to concatenate an string and / or variables but I can't find the
> commands to tear the string apart. If it is even a string.
>
> Can someone point me to the right page in the manual? Or maybe there
> is already a no brainer way to do this. Really just want MM/DD?YYYY.
>
> Thanks for anyhelp....

I'd take a look in the thing we call "the manual". In the "table of
contents" is a heading called "Date and Time Functions" and in there a
sub-heading called "DATE_FORMAT" and another useful one called
"GET_FORMAT".

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

This "manual" thing gets mentioned here quite a lot. Once you
understand what it is and how to use it, you'll find that there are
"manuals" for all sorts of things!

[Back to original message]