Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0DF0647693F for ; Wed, 6 Nov 2002 13:11:30 -0500 (EST) Received: from seapdc01.PNTS (ip63.c216.blk1.bel.nwlink.com [209.20.216.63]) by postgresql.org (Postfix) with ESMTP id E380A4768EB for ; Wed, 6 Nov 2002 13:11:17 -0500 (EST) Received: from busbydev (BUSBY-DEV [10.0.0.64]) by seapdc01.PNTS with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id VLKPF3M3; Wed, 6 Nov 2002 10:16:16 -0800 Message-ID: <01fe01c285bf$72863140$4000000a@busbydev> From: "David Busby" To: Subject: Handling timestampz datatype Date: Wed, 6 Nov 2002 10:08:02 -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 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/14 X-Sequence-Number: 1596 List, How are you all dealing with the timestampz data type in your PG/PHP applications? I cannot seem to find the reliable way to deal with them (for display purposes). My timestampz column comes into my PHP script as a text string, I have to convert (using strtotime()) first then use strftime() to format it. Any ideas on the easy way to do this? /B