Re: Formating TimeStamp

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" <webber@mminternet_spam.com> wrote in message news:3BCD023C.57F5A30@mminternet_spam.com... > 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. >