No problemo! Do this:
select DATE_FORMAT(tidsstampel, '%W %M %Y');
There you go!
Rick
"When a man won't listen to his conscience, it's usually because he doesn't
want advice from a total stranger." - Lindsey Stewart
> From: "Michael Andersson" <[EMAIL PROTECTED]>
> Date: Fri, 12 Apr 2002 14:21:28 +0200
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: Formatting timestamp date in MySQL
>
> I�m kind of new to this mysql stuff but anyway...
>
> I have a row in a table with a timestamp of 14 chars and i dont know how to
> convert the row named 'tidsstampel' into something like this:
>
> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
>
> i dont wanna use a static date for this, id rather use a variable that i get
> from the dbase..
>
> anyone getting this or is it just ribberish?
>
> /Micke
>
> "Mike Robinson" <[EMAIL PROTECTED]> skrev i meddelandet
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>> You should consider using mysql's built-in DATE_FORMAT function.
>> Why pull data, parse it, and format it, when you can retrieve it formatted
>> the way you want in one call. Double/triple handling of data is a bad
> thing.
>>
>>
>> "Nyon" <[EMAIL PROTECTED]> wrote in message
>> 001c01c1dfbd$a7403320$[EMAIL PROTECTED]">news:001c01c1dfbd$a7403320$[EMAIL PROTECTED]...
>> Hi,
>>
>> I need to recall a date data in a MySQL database.
>> The column is set as "date timestamp(8)".
>> A sample of date is "20020409"
>>
>> I use the PHP Date function to format it back to say "9th April 2002".
>> $date_formated = date($date, 'S M Y' );
>> However, it's still doesn't appear as formatted.
>>
>> Anyone mind sharing their code to do this?
>>
>> Nyon
>>
>>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
