title: Using a date as a variable in a where clause
body: <p>How do you use date as a variable in a where clause?  I can't seem to understand how it works.</p>
  
  <pre><code>SELECT MOPACTIVITY.mopid, 
         TO_CHAR(MOPACTIVITY.mopstart, 'yyyy-mm-dd hh24:mi') SOM, 
         TO_CHAR(MOPACTIVITY.mopend, 'yyyy-mm-dd hh24:mi') EOM
  FROM MOPUSER.MOPACTIVITY  
  WHERE MOPACTIVITY.mopstart BETWEEN '01-JAN-14' AND '31-JAN-14'
  </code></pre>
  
  <p>What is the correct syntax for the code above? I am trying to run this from the Oracle SQL Developer.</p>