Re: timestamp with postgresql 7.3 - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: timestamp with postgresql 7.3
Date
Msg-id 20030404140146.W97589-100000@megazone23.bigpanda.com
Whole thread Raw
In response to timestamp with postgresql 7.3  (Claude <pgsql-list@easynet.be>)
Responses Re: timestamp with postgresql 7.3  (Claude <pgsql-list@easynet.be>)
List pgsql-sql
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'



pgsql-sql by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: timestamp with postgresql 7.3
Next
From: Claude
Date:
Subject: Re: timestamp with postgresql 7.3