title: Determine if Oracle date is on a weekend?
body: <p>Is this the best way to determine if an Oracle date is on a weekend?</p>
  
  <pre><code>select * from mytable
  where 
  TO_CHAR (my_date, 'DY', 'NLS_DATE_LANGUAGE=ENGLISH') IN ('SAT', 'SUN');
  </code></pre>