Re: timestamp

["Mitch Vincent" <mitch(at)venux(dot)net>]

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(at)mclink(dot)it>
To: <pgsql-php(at)postgresql(dot)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
>
>
>