Re: [GENERAL] extracting date information?
От | wr@tribe.ping.de |
---|---|
Тема | Re: [GENERAL] extracting date information? |
Дата | |
Msg-id | 19980519223431.25371@tribe.ping.de обсуждение исходный текст |
Ответ на | RE: [GENERAL] extracting date information? ("Jackson, DeJuan" <djackson@cpsgroup.com>) |
Список | pgsql-general |
On Tue, May 19, 1998 at 01:27:02PM -0500, Jackson, DeJuan wrote: > > Now that my dates are being retreived in this format: > > Sat Dec 12 00:00:00 1998 CET > > > > Is there a way to format this to leave off the "time" portion and > > maybe > > the "timezone" info ? > > > Since you're using php why don't you try (with you date datatype): > $date = '1998-05-05'; > list($year, $mon, $day) = explode('-', $date); > echo $date('l M d, Y', mktime(0,0,0,$mon, $day, $year)); I have a similar problem which could be solved if i knew a possibility to convert datetime values to date values. There is only a function provided for the opposite direction. Werner -- Werner Reisberger public-key available: voice: +49 234 540294 Schoellmannstr. 20 pgp-public-keys@keys.pgp.net Fax: +49 234 540239 D-44807 Bochum with "get 0xED527449" in the subject
В списке pgsql-general по дате отправления: