Re: timestamp with postgresql 7.3

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'