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