Postgres Pro
Downloads
Home   >   mailing lists

Thread: timestamp

timestamp

From
Nico D
Date:
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

Re: timestamp

From
"Adam Lang"
Date:
For timestamping in PHP, I use mktime and getdate functions.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Nico D" <nico@mclink.it>
To: <pgsql-php@postgresql.org>
Sent: Sunday, December 03, 2000 4: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
>

Re: timestamp

From
"Mitch Vincent"
Date:
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
>
>
>