At 05:46 AM 9/10/03, 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);
The input to php "date" function is a unix timestamp, not a string.
Use:
select date_part('epoch',order_date) from ...
instead of
select order_date from ...
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
