Both of these work OK for me
date('r',strtotime($record->date_field));
or
select to_char(date_field,'FORMAT SPEC') as date_field, column_two,
column_three from x where y=z
/B
----- Original Message -----
From: "Michael Hanna" <zen(at)hwcn(dot)org>
To: <pgsql-php(at)postgresql(dot)org>
Sent: Monday, June 30, 2003 12:54
Subject: [PHP] Best way to convert PG's TIMESTAMPTZ to PHP DATE?
> Anybody have any advice on this..
> Michael
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>