title: SQL Date Format Conversion
body: <p>I have a question regarding SQL dates.
  The table I am working with has a date field in the following format: "22-SEP-08". The field is a date column.</p>
  
  <p>I am trying to figure out how to output records from 1/1/2000 to present day.</p>
  
  <p>The code below is not filtering the date field:</p>
  
  <pre><code>Select distinct entity.lt_date 
  from feed.entitytable entity 
  where entity.lt_date &gt;= '2000-01-01'
  </code></pre>
  
  <p>Any help regarding this issue is much appreciated. Thanks!</p>
  
  <p>Edit: I am using Oracle SQL Developer to write my code.</p>