title: Select Query using SYSDATE
body: <p>The Employee table has four fields EmpNo,EmpName,FromDate and ToDate filelds. I have to select the EmpNo and EmpName where today’s date is between the from date and the to date.</p>
  
  <pre><code>Select EmpNo,EmpName from Employee where FromDate = Trunc(SYSDATE) And ToDate =Trunc(SYSDATE)
  </code></pre>
  
  <p>Is that the way of doing</p>