Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5EHNUE02041 for ; Thu, 14 Jun 2001 13:23:30 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f5EHMb018474; Thu, 14 Jun 2001 13:22:37 -0400 (EDT) To: Vivek Khera cc: pgsql-sql@postgresql.org Subject: Re: Re: Timestamp without time zone In-reply-to: <15144.55328.741285.104733@onceler.kciLink.com> References: <15144.55328.741285.104733@onceler.kciLink.com> Comments: In-reply-to Vivek Khera message dated "Thu, 14 Jun 2001 11:28:32 -0400" Date: Thu, 14 Jun 2001 13:22:37 -0400 Message-ID: <18471.992539357@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/216 X-Sequence-Number: 3474 Vivek Khera writes: > AP> Why do you _want_ to remove timezone from values in database? There is > AP> definitely a way to work around whatever problem you are having. > Because my normal date parsing routines from perl's Date::Parse > library don't recognize it, and fail to parse the date. Leaving aside the question of whether Date::Parse isn't broken and in need of fixing (the timestamp output format *is* ISO compliant), it would seem that your answer lies in using to_char() to format the timestamp value the way your client code wants, rather than expecting the default output format to exactly meet your needs. You're not really asking for a timestamp without timezone in the database, you're asking how to suppress the timezone during display. regards, tom lane