Обсуждение: 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
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 >
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 > > >