1. Check out our companion app, Forums for Android! Download from Google Play

Java Date Comparison with sqlite date

Discussion in 'Application Development' started by beedge, Jul 22, 2010.

  1. beedge

    beedge New Member
    Thread Starter

    Jul 20, 2010
    Hey all.,

    Im still quite new to Android and havent done Java since I left college 7 years ago, my background is in php and I never realised how convenient teh strtotime and date functions in that language are!

    My problem is that I am trying to store a date in my sqlite database and retrieve it to compare with a java date object (i.e todays date)

    Ive tried everything I can find on the net but nothing seems to work.

    what I want to do specificly is check to see if the last use of the app occurred before or after today (i.e 12.01am)

    is there any pointers on how to do this? the most common error I am running into is that date type java.utils.date and java.sql.date are incompatible

    I want them to be date objects because I want to use something like

    if ( date1.isbefore(date2) ){

    is there any one out there who has run into similar problems?

    if so, PLEASE HELP"!!!!

    its driving me batty!



  2. jonbonazza

    jonbonazza Well-Known Member

    Jul 13, 2010
    You could retreive the date from the database in a string and then convert it to a java date.

Share This Page