title: oracle plsql order by on Date Of Birth column does not work
body: <p>I have a table called datetest </p>
  
  <pre><code>CREATE TABLE "DATETEST"."DATETEST" 
     ("FNAME" VARCHAR2(20 BYTE), 
  "DOB" DATE, 
  "STAFFNO" NUMBER NOT NULL ENABLE, 
   CONSTRAINT "DATETEST_PK" PRIMARY KEY ("STAFFNO"));
  </code></pre>
  
  <p>with the following data </p>
  
  <pre><code>INSERT INTO "DATETEST"."DATETEST" (FNAME, DOB, STAFFNO) VALUES ('John', TO_DATE('01-   OCT-45', 'DD-MON-RR'), '1')
  INSERT INTO "DATETEST"."DATETEST" (FNAME, DOB, STAFFNO) VALUES ('Ann', TO_DATE('01-NOV-60', 'DD-MON-RR'), '2')
  INSERT INTO "DATETEST"."DATETEST" (FNAME, DOB, STAFFNO) VALUES ('David', TO_DATE('24-MAR-58', 'DD-MON-RR'), '3')
  INSERT INTO "DATETEST"."DATETEST" (FNAME, DOB, STAFFNO) VALUES ('Mary', TO_DATE('19-FEB-70', 'DD-MON-RR'), '4')
  INSERT INTO "DATETEST"."DATETEST" (FNAME, DOB, STAFFNO) VALUES ('Susan', TO_DATE('03-JUN-40', 'DD-MON-RR'), '5')
  INSERT INTO "DATETEST"."DATETEST" (FNAME, DOB, STAFFNO) VALUES ('Julie', TO_DATE('13-JUN-65', 'DD-MON-RR'), '6')
  </code></pre>
  
  <p>when i do execute the following query</p>
  
  <pre><code>select * from datatest order by dob desc 
  </code></pre>
  
  <p>i get the following result</p>
  
  <pre><code>FNAME                DOB       STAFFNO
  -------------------- --------- -------
  John                 01-OCT-45       1 
  Susan                03-JUN-40       5 
  Mary                 19-FEB-70       4 
  Julie                13-JUN-65       6 
  Ann                  01-NOV-60       2 
  David                24-MAR-58       3 
  </code></pre>
  
  <p>I cannot figure out how to get the correct order.  How do I query the correct order?</p>