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
------------------------------------------------------------------
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 |