extracting date information?

Поиск
Список
Период
Сортировка
От Kevin Heflin
Тема extracting date information?
Дата
Msg-id 3560F45F.989A4BE9@shreve.net
обсуждение исходный текст
Ответы Re: [GENERAL] extracting date information?  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
Список pgsql-general
Any hints or clues on this one?
Using Postgresql6.3 and PHP2

I have a simple database with a list of events, one of the fields is of
the data type "date".

When I call this information from the database, it prints out the date
in the form of "1998-05-05"

What I would really like to do, when this date is retrieved, Is to
format it something like "Thursday May 5, 1998" Anything more
descriptive than "1998-05-05" would be great.

I've tried using the "date(format,date)" call from PHP by saving the
date in a variable, then:
echo date("YMdl","$thedate");

But when it is displayed it always prints out this date:
"1969Dec31Wednesday"

Any suggestions or comments would be appreciated.

Kevin

--
------------------------------------------------------------------
Kevin Heflin       | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech        | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
------------------------------------------------------------------

В списке pgsql-general по дате отправления:

Предыдущее
От: Dave Johnson
Дата:
Сообщение: Problems in pgc.l for hpux 10.20
Следующее
От: Philip Bierhoff
Дата:
Сообщение: About Deleting Large Objects