title: SQL: How to data of current date from timestamp field in oracle?
body: <p>How to data of current date from timestamp field in oracle?</p>
  
  <pre><code>select
   jobstatus0_.JOBNAME as JOBNAME1_21_,
   jobstatus0_.STARTDATE as STARTDATE2_21_,
   jobstatus0_.ENDDATE as ENDDATE3_21_,
   jobstatus0_.REMARKS as REMARKS4_21_,
    jobstatus0_.STATUS as STATUS5_21_
   from
     PD_OWNER.CIM_SNOW_JOB_STATUS_TAB jobstatus0_
    where
   jobstatus0_.JOBNAME='AGREEMENTS'
   AND jobstatus0_.STARTDATE=sysdate &lt;-- Not working with this
  </code></pre>
  
  <p>We need not to consider Time but date only</p>
  
  <p>I tried following but it is also not working.</p>
  
  <pre><code>and cast(jobstatus0_.STARTDATE as date)=sysdate
  </code></pre>
  
  <p>Also used which worked</p>
  
  <pre><code>AND  to_date(to_char(jobstatus0_.STARTDATE,'DD-MON-YYYY'))=to_date(to_char(sysdate,'DD-MON-YYYY'));
  </code></pre>
  
  <p>but want more elegant way.</p>