http://www.postgresql.org/devel-corner/docs/postgres/datetime-functions.htm
More specifically :
date_part('epoch',<timestamp>)
You can pass that to PHP's date() function and format the time to your
liking.
-Mitch
----- Original Message -----
From: "Nico D" <nico@mclink.it>
To: <pgsql-php@postgresql.org>
Sent: Sunday, December 03, 2000 1:53 AM
Subject: [PHP] timestamp
> Is there any function that converts the internal PG timestamp format into
unix
> timestamp format?
>
> Or viceversa, is there a PHP function that formats properly
> the PG timestamp according to the setlocale setting?
>
> I'm trying to get the CPU-wasteless time conversion.
> (I'm using PG 7.0.2)
>
> Thanks
> Nico
>
>
>