oracle query with date
Posted on 2013-02-07
where site_code = 'WC24'
and drive_date between '01-jan-2013' and '31-dec-2013'
If I take min(drive_date) I get 6/5/2013
But I need the next drive_date (6/5/2013). Is there a way in oracle to get the next from the min. The criteria is I want to get drive_date greater than system date I mean 1/17/2013 is past date.