0

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:

enter image description here

date / time is taking value(by date/time dialogs) after the create of this activity,then user can change it if he wants.

I want in another activity to have listview of measures by descending date + time.

I want also to be able to fetch the measures of last 1 / 7 / 30 days.

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?

oikonomopo
  • 4,025
  • 7
  • 44
  • 73

1 Answers1

3

You should use System.currentTimeMillis() and store that BIGINT value in the table. You can parse the time with something like this:

    SimpleDateFormat sdf = new SimpleDateFormat("MM dd,yyyy HH:mm");

    Date resultdate = new Date(yourmilliseconds);
    System.out.println(sdf.format(resultdate));

Source: How to transform currentTimeMillis to a readable date format?

Community
  • 1
  • 1
Jack Satriano
  • 1,999
  • 1
  • 13
  • 17
  • I want also to be able to fetch the measures of last 1 / 7 / 30 days How i could do that with this way? – oikonomopo Sep 13 '12 at 06:25
  • I'm not sure I understand you, this will give you the current date and time of the device. If you want to create a Date object, there is documentation online for that. – Jack Satriano Sep 13 '12 at 13:29