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
Post a Comment