java - Storing Date integer in SQLiteDatabase from original String value -


i'm using extendedcalendarview library store information events loaded calendar view.

as can see documentation there columns startdate enddate start , end have data type integer

now, event data downloaded csv file client provides , updates himself. of data of type string example "26/04/2014".

how can modify/convert original string value inserted sqlite database accepted appropriate data type? please see below current conversion code , error i'm getting.

public static int convertdatestring(string datestring) throws parseexception {     datestring = datestring.replace("/", "-");     dateformat df = new simpledateformat("dd-mm-yy");     date date = df.parse(datestring); //turn string date object      string s = df.format(date);     int result = integer.valueof(s);     return result; } 

error produced:

03-24 19:13:38.028: e/androidruntime(10279): caused by: java.lang.numberformatexception: invalid int: "26.04.14" 03-24 19:13:38.028: e/androidruntime(10279):    @ java.lang.integer.invalidint(integer.java:138) 03-24 19:13:38.028: e/androidruntime(10279):    @ java.lang.integer.parse(integer.java:375) 03-24 19:13:38.028: e/androidruntime(10279):    @ java.lang.integer.parseint(integer.java:366) 03-24 19:13:38.028: e/androidruntime(10279):    @ java.lang.integer.parseint(integer.java:332) 03-24 19:13:38.028: e/androidruntime(10279):    @ java.lang.integer.valueof(integer.java:490) 03-24 19:13:38.028: e/androidruntime(10279):    @ uk.ac.aber.dwd.ceredigiontourism.calendaractivity.convertdatestring(calendaractivity.java:160) 

any provided appreciated.

you can store date int following date.gettime();.

restore date date = new date(storedtime);


Comments

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

google shop client API returns 400 bad request error while adding an item -