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