Re: Extracting Time??
| From: | Jason Wong | Date: | Sun, 16 Jun 2002 17:09:00 +0000 |
| Subject: | Re: Extracting Time?? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19836@lists.php.net to get a copy of this message | ||
On Sunday 16 June 2002 16:20, César Aracena wrote:
> Well... actually, I care about displaying it in Spanish instead of
> English ( Enero instead of January). Does anybody has accomplished this
> for Spanish or any other language? Is it possible?
> > Hi all and sorry for bothering again.
> >
> > I need to fetch one time and date from a MySQL DB where is stored as
> > TIMESTAMP (YYYYMMDDHHMMSS) to print it in a page but in common format
> > (DD MM YYYY at HH:MM:SS). Actually, I dont care bout the st, nd and
>
> th
>
> > extensions after the day.
When retrieving the dates from your table convert it a Unix timestamp, then in
php use strftime().
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
"Only a brain-damaged operating system would support task switching and not
make the simple next step of supporting multitasking."
-- George McFry
*/