title: How to android + sqlite + date + time?need date/time operations
body: <p>I have an activity where i want to to save some measures data into a sqlite database(i will have only insert option).The xml  is:</p>
  
  <p><img src="https://i.stack.imgur.com/3yLNf.png" alt="enter image description here"></p>
  
  <p>date / time is taking value(by date/time dialogs) after the create of this activity,then user can change it if he wants.</p>
  
  <p>I want in another activity to have listview of measures by descending date + time.</p>
  
  <p>I want also to be able to fetch the measures of last 1 / 7 / 30 days.</p>
  
  <p>What is the best way to make the sqlite table?How i should save date + time?together?or not?as TEXT or REAL or INTEGER so that can i easily make the above operations?</p>