title: current month values in oracle db
body: <p>how to get current month to date values in oracle 12c sql developer</p>
  
  <pre><code>Select dcc.EMPLOYEECODE, dcc.DUTYID, dtt.DUTYDESC 
  from DUTYCHART dcc
    join DCDUTYCHART dtt 
     on dcc.RESTCODE = dtt.RESTCODE 
    and dcc.DUTYID = dtt.DUTYID
    and trunc(date) = trunc(sysdate)
  </code></pre>
  
  <p>Here am getting current date but I want to show current month and previous month, I tried some functions like add-months but it didn't worked for me</p>