title: sqlite datetime format: which one is better?
body: <p>I'm creating a sqlite database from my c# project which will be used in my android application later on. </p>
  
  <p>I have a <b>CreateDate</b> column in my sqlite database which I will need to get records ordered by this column later in my android application. Now my question is that is it better to save the date time as TEXT with <b>YYYY-MM-DD HH:MM:SS</b> format or I just convert all my dates into <b>miliseconds</b> and order them easily later since it's just a number? </p>
  
  <p>Which one is easier to be ordered later in mobile application? or maybe my approaches are wrong so please feel free to shoot me with some best practices for this situation.</p>
  
  <p>Thanks in advance.</p>