From: Andrew - Supernews <andrew+nonews@supernews.com>
To: pgsql-sql@postgresql.org
Subject: Re: definative way to place secs from epoc into timestamp
Date: Thu, 03 Mar 2005 20:58:14 -0000
Message-ID: <slrnd2euj5.29om.andrew+nonews@trinity.supernews.net> (raw)
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>
On 2005-03-03, Bret Hughes <bhughes@elevating.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andrew+nonews@supernews.com
Subject: Re: definative way to place secs from epoc into timestamp
In-Reply-To: <slrnd2euj5.29om.andrew+nonews@trinity.supernews.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox