title: How to retrieve formated date field in sqlite in my android code?
body: <p>I have following code in my android program:</p>
  
  <pre><code>Cursor cursor = db.rawQuery("select ID,firstname,date(birthday) from user", null);  
  String birthdaystr=cursor.getString(2);
  </code></pre>
  
  <p>But the value of birthdaystr is null.</p>
  
  <p>I changed my code to:</p>
  
  <pre><code>Cursor cursor = db.rawQuery("select ID,firstname,birthday from user", null);  
  String birthdaystr=cursor.getString(2);
  </code></pre>
  
  <p>The value of birthdaystr looks like "Wed Jan 10 00:00:00 +0000 1973".</p>
  
  <p>Anybody know this issue? (It seems I need to get the value by another way if I use date() function)</p>