title: to_date function with sysdate
body: <pre><code>select TO_CHAR(to_date(sysdate, 'DD-MON-YYYY'), 'DAY') FROM DUAL; 
  </code></pre>
  
  <p>When I run this query the output was : SUNDAY. But we know today is Tuesday(1-1-2013).
  And</p>
  
  <p>then changed the query as </p>
  
  <pre><code>select TO_CHAR(to_date('01-JAN-2013', 'DD-MON-YYYY'), 'DAY') FROM DUAL;
  </code></pre>
  
  <p>answer was :TUESDAY. </p>
  
  <p>then Changed query as </p>
  
  <pre><code>select TO_CHAR(to_date(sysdate+1, 'DD-MON-YYYY'), 'DAY') FROM DUAL;
  </code></pre>
  
  <p>answer is :MONDAY.</p>
  
  <p>When I using the sysdate why it is show SUNDAY as output?</p>
  
  <p>I am new in oracle db. Please help me.</p>