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 2CB8C52A4D for ; Sat, 5 Mar 2005 00:45:50 +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 53916-06 for ; Sat, 5 Mar 2005 00:45:40 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 54F495551E for ; Sat, 5 Mar 2005 00:45:40 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id ABBE931DCC; Sat, 5 Mar 2005 01:45:43 +0100 (MET) From: Andrew - Supernews X-Newsgroups: pgsql.sql Subject: Re: definative way to place secs from epoc into timestamp Date: Sat, 05 Mar 2005 00:45:42 -0000 Organization: http://www.supernews.com - all your nntp are belong to us Message-ID: References: <000d01c520cb$0e7a6780$797ba8c0@jfradkin> Reply-To: andrew@supernews.com User-Agent: slrn/0.9.8.0 (FreeBSD) X-Complaints-To: abuse@supernews.com Lines: 9 To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/72 X-Sequence-Number: 20551 On 2005-03-04, "Joel Fradkin" wrote: > Just so I don't make a newb mistake I should use timestamptz not timestamp > where the exact moment is important? Yes. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services