Re: Frustration with date/times/epoch in v7.3.

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