Re: convert from epoch to timestamp

On Fri, May 06, 2005 at 19:39:26 -0500,
Celia McInnis <celia(at)drmath(dot)ca> wrote:
> This time I'll give an appropriate subject...

Please don't reply to existing threads to start a new one, even if you change
the subject.

> How to I convert from EPOCH time to a "TIMESTAMP WTHOUT TIME ZONE" type?

The simplest is probably:
select 1::abstime at time zone 'UTC';
Where you replace '1' by whatever number has the integer number of seconds
since the epoch. If you need fractional seconds then you need to multiply
the number seonds times and interval of 1 second and add it to the
the start of the epoch.