Thanks Peter, abstime() seems to do the trick. However this paragraph
from the docs worries me:
"The types abstime and reltime are lower precision types which are used
internally. You are discouraged from using any of these types in new
applications and are encouraged to move any old ones over when
appropriate. Any or all of these internal types might disappear in a
future release."
So does this mean that the abstime() functions may dissappear in the
future? I'd rather not have to go through and change all my queries yet
again, is there a function that has a better chance of being around in
the near future that I could use instead?
On Thu, 2002-12-12 at 09:59, Peter Gibbs wrote:
> Mike Benoit wrote:
>
> > select imported_date, ('Jan 1 1970'::DATE + (imported_date || '
> seconds')::INTERVAL)::timestamp from server_accounts limit 1
> > imported_date | timestamp
> > ---------------+---------------------
> > 1027966107 | 2002-07-29 18:08:27
>
> test=> select imported_date, abstime(imported_date) from server_accounts;
> imported_date | abstime
> ---------------+------------------------
> 1037498593 | 2002-11-17 04:03:13+02
> 1027966107 | 2002-07-29 20:08:27+02
>
> --
> Peter Gibbs
> EmKel Systems
--
Best Regards,
Mike Benoit
NetNation Communication Inc.
Systems Engineer
Tel: 604-684-6892 or 888-983-6600
---------------------------------------
Disclaimer: Opinions expressed here are my own and not
necessarily those of my employer