pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedtimestamp
3+ messages / 3 participants
[nested] [flat]
* timestamp
@ 2000-12-03 09:53 Nico D <nico@mclink.it>
2000-12-04 01:39 ` Re: timestamp Mitch Vincent <mitch@venux.net>
2000-12-04 13:54 ` Re: timestamp Adam Lang <aalang@rutgersinsurance.com>
0 siblings, 2 replies; 3+ messages in thread
From: Nico D @ 2000-12-03 09:53 UTC (permalink / raw)
To: pgsql-php
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: timestamp
2000-12-03 09:53 timestamp Nico D <nico@mclink.it>
@ 2000-12-04 01:39 ` Mitch Vincent <mitch@venux.net>
1 sibling, 0 replies; 3+ messages in thread
From: Mitch Vincent @ 2000-12-04 01:39 UTC (permalink / raw)
To: Nico D <nico@mclink.it>; pgsql-php
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
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: timestamp
2000-12-03 09:53 timestamp Nico D <nico@mclink.it>
@ 2000-12-04 13:54 ` Adam Lang <aalang@rutgersinsurance.com>
1 sibling, 0 replies; 3+ messages in thread
From: Adam Lang @ 2000-12-04 13:54 UTC (permalink / raw)
To: pgsql-php
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-12-04 13:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-03 09:53 timestamp Nico D <nico@mclink.it>
2000-12-04 01:39 ` Mitch Vincent <mitch@venux.net>
2000-12-04 13:54 ` Adam Lang <aalang@rutgersinsurance.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox