Re: epoch to timestamp

Larry,

> I actually have just seconds (from my LD carrier), and want to store it in
> hours/minutes/seconds.

If you store it as an interval, you will end up with:

staffos=# select '12742329 seconds'::INTERVAL;    interval
-------------------147 days 11:32:09

In fact, you can't avoid interval conversion to days, hours, minutes.

--
Josh Berkus
Aglio Database Solutions
San Francisco