Re: Formating TimeStamp
| From: | Jason | Date: | Wed, 17 Oct 2001 03:59:56 +0000 |
| Subject: | Re: Formating TimeStamp | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13407@lists.php.net to get a copy of this message | ||
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.