title: How to get min date using oracle database date table
body: <p><img src="https://i.stack.imgur.com/WHhis.png" alt="enter image description here"></p>
  
  <p>here is my sql query</p>
  
  <pre><code>select e.event_name,
      min(dt.start_date) as start_date,
      min(dt.start_date)||'-'||max(dt.end_date) as FromTo
  from event e join
      date_table dt
  on e.e_id = dt.e_id
  group by e.event_name;
  </code></pre>
  
  <p>I want to get upcomming events. For that, I use  <code>MAX(dt.end_date)&gt;=sysdate</code> then i got the upcomming events. But my problem is, when an event happens today, tomorrow and day after tomorrow, I display start date as "today"(minimum start date). 
  But when tomorrow comes, still I showed start date as previous date. Because minimum start date is yesterday. i want to display tomorrow date as the start date. </p>
  
  <p>How should I change my code?</p>