Re: Returning The Closest Single Value

"Barry Warner" <bwarner_at_blueyonder.co.uk> wrote in message news:K3ur9.29254$jR.14136_at_news-binary.blueyonder.co.uk...
> Hi
>
> I need to compare the system date with the first available date in
> workshop_start_date column. How do I only return the closest date?

select min(abs(sysdate-workshop_start_date)) from .... where....;

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************