Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2MKnmw15834 for ; Thu, 22 Mar 2001 15:49:48 -0500 (EST) (envelope-from phpPgAdmin@acucore.com) Received: from utahdemo.corp.peoplesoft.com ([205.172.150.78]) by mail1.hub.org (8.11.3/8.11.1) with ESMTP id f2MKMnj08187 for ; Thu, 22 Mar 2001 15:22:57 -0500 (EST) (envelope-from phpPgAdmin@acucore.com) Received: from dwilsonuta ([207.135.57.84]) by utahdemo.corp.peoplesoft.com with Microsoft SMTPSVC(5.0.2172.1); Thu, 22 Mar 2001 12:33:45 -0700 Message-ID: <00cf01c0b307$02ac4080$543987cf@corp.peoplesoft.com> From: "Dan Wilson" To: "Richie" , References: Subject: Re: Converting POSTGRESQL timestamp to UNIX timestamp Date: Thu, 22 Mar 2001 12:33:45 -0700 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.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-OriginalArrivalTime: 22 Mar 2001 19:33:45.0895 (UTC) FILETIME=[02C48370:01C0B307] X-Archive-Number: 200103/49 X-Sequence-Number: 234 http://www.php.net/manual/en/function.strtotime.php : Hi : : I have a field of type timestamp in my database but when I retrieve it I : want to convert it to its unix timetamp value because I need to compare 2 : tables by their timestamp value. : : Any ideas how to convert PostgreSQL timestamp to Unix timestamp??? : : Thanks : : Richie