Grant Henderson wrote:
> How do I convert a postrgesql timestamp
> To an english date
>
> E.g.
> $order_date = "2003-09-10 09:40:30+01";
> $date = date("d/M/Y", $order_date);
> print($date);
>
Why not just do it in the database before you get to the PHP?
=# SELECT to_char(now(), 'Month-fmdd-yyyy'::text);
to_char
-------------------
September-10-2003
(1 row)
More info:
http://www.postgresql.org/docs/7/interactive/functions2976.htm
Hope that can help,
-Robby
--
Robby Russell, | Sr. Administrator / Lead Programmer
Command Prompt, Inc. | http://www.commandprompt.com
rrussell@commandprompt.com | Telephone: (503) 222.2783
