extracting date information?

From: Kevin Heflin <kheflin(at)shreve(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: extracting date information?
Date: 1998-05-19 02:54:23
Message-ID: 3560F45F.989A4BE9@shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Bierhoff 1998-05-19 09:15:25 About Deleting Large Objects
Previous Message Dave Johnson 1998-05-18 20:41:00 Problems in pgc.l for hpux 10.20