| 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: | Whole Thread | Raw Message | 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 |