Thanks for all of the input. Here is the solution that I finally went: DATE_FORMAT(v_date, '%b %e, %Y') AS v_date
v_date being the column name. -- Jason L. West, Sr. Web Architect SalesTek Inc. "Jason" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > DATE_FORMAT is a MySQL function. > > the info is on the following page: > http://www.mysql.com/doc/D/a/Date_and_time_functions.html > > Jason wrote: > > > Yuu may wanna look at the DATE_FORMAT(date,format) function > > > > "Jason L. West" wrote: > > > > > I am finding it hard to find an answer to a what I assume a common question. > > > What is the best way of formatting results of a timestamp from MySQL? > > > > > > Current time stamp appears as: > > > > > > 20011016192904 > > > > > > Which in translation is Year, Month, Day, Hour, Minute, Seconds > > > > > > Any suggestions? > > > > > > Thanks > > > > > > -- > > > Jason L. West, Sr. > > > Web Architect > > > SalesTek Inc. > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]