title: how to sort date which stored in database with string
body: <p>I am trying to sort </p>
  
  <blockquote>
    <p>SELECT * FROM myTable ORDER BY DATE(date)     // <code>date</code> is stored with string</p>
  </blockquote>
  
  <p>Here is the LogCat</p>
  
  <pre><code>11-22 12:50:50.906: I/DB(31388): get :17 Nov 2013 09:36:01
  11-22 12:50:50.906: I/DB(31388): get :13 Nov 2013 07:41:29
  11-22 12:50:50.907: I/DB(31388): get :12 Nov 2013 11:09:46
  11-22 12:50:50.907: I/DB(31388): get :08 Nov 2013 09:13:26
  11-22 12:50:50.908: I/DB(31388): get :02 Nov 2013 08:54:26
  11-22 12:50:50.908: I/DB(31388): get :27 Oct 2013 08:02:09
  11-22 12:50:50.908: I/DB(31388): get :26 Oct 2013 07:42:18
  11-22 12:50:50.908: I/DB(31388): get :21 Oct 2013 06:45:18
  11-22 12:50:50.909: I/DB(31388): get :19 Oct 2013 07:38:43
  11-22 12:50:50.909: I/DB(31388): get :16 Oct 2013 03:12:16
  </code></pre>
  
  <p><strong>UPDATE from HERE============>>></strong></p>
  
  <p>This is not return <code>long</code> value. It is always <code>return 0</code>.</p>
  
  <pre><code>    try {
          DateFormat sdf = new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss z", Locale.US);
          Date date = sdf.parse(dateTime);
          long milliseconds = date.getTime();
          return milliseconds;
      } catch (Exception e) {
          e.printStackTrace();
          Log.i("DB", "err :" + e);
          return 0;
      }
  </code></pre>
  
  <p>I want to sort with latest date 
  can anyone spent some time for me..
  Thanks in advance.</p>