Received: from thor.tht.net (thor.tht.net [209.47.145.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB4I3MG06239 for ; Mon, 4 Dec 2000 13:03:22 -0500 (EST) (envelope-from mitch@venux.net) Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by thor.tht.net (8.9.3/8.9.3) with ESMTP id DAA37177 for ; Mon, 4 Dec 2000 03:29:27 GMT (envelope-from mitch@venux.net) Received: from windows (cx853045-b.phnx1.az.home.com [24.177.75.28]) by icebox.venux.net (Postfix) with SMTP id 6EAFC26202; Sun, 3 Dec 2000 19:46:56 -0500 (EST) Message-ID: <003901c05d93$13479d50$0200000a@windows> From: "Mitch Vincent" To: "Nico D" , References: <6454.001203@mclink.it> Subject: Re: timestamp Date: Sun, 3 Dec 2000 17:39:42 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200012/3 X-Sequence-Number: 46 http://www.postgresql.org/devel-corner/docs/postgres/datetime-functions.htm More specifically : date_part('epoch',) You can pass that to PHP's date() function and format the time to your liking. -Mitch ----- Original Message ----- From: "Nico D" To: 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 > > >