Re: timestamp with postgresql 7.3

From: Claude <pgsql-list(at)easynet(dot)be>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: timestamp with postgresql 7.3
Date: 2003-04-05 00:21:36
Message-ID: Pine.LNX.4.51.0304050216160.27043@bar.noc.be.easynet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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'

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message A.M. 2003-04-05 01:58:38 UNION and ORDER BY ... IS NULL ASC
Previous Message Lee Harr 2003-04-04 22:58:16 Re: Difficult query (for me)