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

Reply via email to