title: Oracle SQL - How do i output data from a table based on the day of the week from a hiredate column?
body: <p>To be specific: I have a table with lets day 6 columns, one of which is Hiredate. the Hiredate is of the the type DATE and in the form of dd-Mon-YY. Now I am trying to only output the rows of data which have a hiredate of Monday or Tuesday. </p>
  
  <p>Currently i am trying to do something along the lines of:</p>
  
  <pre><code>SELECT name, position, hiredate
  FROM table
  WHERE hiredate = 'monday';
  </code></pre>
  
  <p>or </p>
  
  <pre><code>SELECT TO_CHAR(hiredate, 'day') 
  FROM table
  WHERE TO_CHAR(hiredate, 'day') = 'monday';
  </code></pre>
  
  <p>neither of these work, and neither do any of the other variations of SQL that I have tried.</p>
  
  <p>I'm fairly certain this is extremely simple, but I am a beginner and am kind of lost on where to go. Any help or tips would be appreciated.</p>