X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 185955639B for ; Thu, 3 Mar 2005 20:58:30 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96079-02 for ; Thu, 3 Mar 2005 20:58:21 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1242E5513E for ; Thu, 3 Mar 2005 20:58:20 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id E7D3F3209C; Thu, 3 Mar 2005 21:58:21 +0100 (MET) From: Andrew - Supernews X-Newsgroups: pgsql.sql Subject: Re: definative way to place secs from epoc into timestamp Date: Thu, 03 Mar 2005 20:58:14 -0000 Organization: http://www.supernews.com - all your nntp are belong to us Message-ID: References: <1109780719.28180.86.camel@bretsony> <13089.1109793126@sss.pgh.pa.us> <1109794066.27857.100.camel@bretsony> <13466.1109795186@sss.pgh.pa.us> <1109828560.27905.137.camel@bretsony> <2bf00b6e6300e2c76bc3c09fa89e7913@myrealbox.com> <1109834845.27905.147.camel@bretsony> Reply-To: andrew@supernews.com User-Agent: slrn/0.9.8.0 (FreeBSD) X-Complaints-To: abuse@supernews.com Lines: 15 To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/54 X-Sequence-Number: 20533 On 2005-03-03, Bret Hughes wrote: > a RFE would be to let to_timestamp be to a timezone without time zone > and have a to_timestamptz do the time zone thing. Seems more consistent > and would give me the functionality I am looking for :) Unix epoch times correspond to timestamp _with_ time zone. (Why are you using timestamp without time zone anyway? For recording the time at which an event occurred that usage is simply wrong - in fact I can't see any situation in which a Unix epoch time can correctly be converted to a timestamp without time zone.) -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services