>> try this: >> select mytime from mytable order by abs(extract(epoch from >> (usertime-mytime))) asc limit 5;
>> SELECT ts_fld2,abs(extract(epoch from '2011-03-25 >> 14:15:25-07'::timestamptz)-extract(epoch from ts_fld2)) from timestamp_test >> order >> by abs(extract(epoch from '2011-03-25 >> 14:15:25-07'::timestamptz)-extract(epoch >> from ts_fld2)) limit 5; Thanks to Ondrej and Adrian, who both provided working solutions using extract/epoch. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
