Tamas,

select min( abs( datetime1 - datetime2 ) ) ...

>I'd like to find a datetime field in a table which is the nearest to a certain given datetime. What functions can be used? And Any idea would be appreciated.
>
>Another different question:
>I haven't been in this site for a long time and now I cannot search in the monthly archive. Has that section been removed?