pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Claude <pgsql-list@easynet.be>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: timestamp with postgresql 7.3
Date: Sat, 5 Apr 2003 02:21:36 +0200 (CEST)
Message-ID: <Pine.LNX.4.51.0304050216160.27043@bar.noc.be.easynet.net> (raw)
In-Reply-To: <20030404140146.W97589-100000@megazone23.bigpanda.com>
References: <20030404140146.W97589-100000@megazone23.bigpanda.com>

Thanks, that made the trick.


On Fri, 4 Apr 2003, Stephan Szabo wrote:

>
> On Fri, 4 Apr 2003, Claude wrote:
>
> > I have a table a field with timestamps in seconds since epoch and I would
> > like to get a human readable date... but it seems that postgresql 7.3 does
> > not support the datetime(), timestamp(), timestamptz() functions...
>
> I'd say probably something like:
>
> CAST('epoch' as timestamp with time zone) + integerfield * INTERVAL '1 second'




view thread (4+ messages)

Message-ID: <Pine.LNX.4.51.0304050216160.27043@bar.noc.be.easynet.net>
Permalink:  ../Pine.LNX.4.51.0304050216160.27043@bar.noc.be.easynet.net/
Also on:    postgresql.org/message-id/Pine.LNX.4.51.0304050216160.27043@bar.noc.be.easynet.net

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: pgsql-list@easynet.be, sszabo@megazone23.bigpanda.com
  Subject: Re: timestamp with postgresql 7.3
  In-Reply-To: <Pine.LNX.4.51.0304050216160.27043@bar.noc.be.easynet.net>
  References: <20030404140146.W97589-100000@megazone23.bigpanda.com> <Pine.LNX.4.51.0304050216160.27043@bar.noc.be.easynet.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