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" <mrobinson@torontostartv.com> skrev i meddelandet news:20020410171301.21580.qmail@pb1.pair.com... > 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" <ycnyon@pd.jaring.my> wrote in message > news:001c01c1dfbd$a7403320$7464a8c0@tm.net.my... > 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 > >