In my table mytable I have Date column.
how is the query to find the nearest date in mytable to current date ?
what exactly you are storing in the table ?
table structure please.
select * from mytable order by abs(mydate-sysdate)
I have tried Ultrivedi answer but it didn't work.
This is mytable structure
My question solved
ultivredi's answer solve my problem .only need () following sysdate