Re: [PHP] Re: Formatting timestamp date in MySQL

2002-04-12 Thread Richard Baskett
<[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

[PHP] Re: Formatting timestamp date in MySQL

2002-04-12 Thread Michael Andersson
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 u

[PHP] Re: Formatting timestamp date in MySQL

2002-04-10 Thread Mike Robinson
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 PROTEC