Timestamp format

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

Re: Timestamp format

On 27 Apr, 06:58, Ron 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-functio ns.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!

Re: Timestamp format

"Ron" wrote in message
news:pc33331mns07ump4b042solbgs84c0ce2b@4ax.com...
> 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....

that'll be substr(), then ;-)

D.
--
googlegroups > /dev/nul

Re: Timestamp format

On Fri, 27 Apr 2007 17:52:17 GMT, "Virginner"
wrote:

>"Ron" wrote in message
>news:pc33331mns07ump4b042solbgs84c0ce2b@4ax.com...
>> 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....
>
>that'll be substr(), then ;-)
>
>D.
Awesome! Just found my old PHP book and was 2 pages before this on
string manipulation. :)
Thanks a bunch!

Re: Timestamp format

Post removed (X-No-Archive: yes)