Parsing string to java.sql.date -


i hope can me. input 22-01-1993

my code is

public string createcalendar (string titel, string startdate, string enddate, string note, string location, string email) throws sqlexception, parseexception {     string stringtobereturned ="";     testconnection();      simpledateformat format = new simpledateformat ("eee mmm dd hh:mm:s zzz yyyy");      java.util.date utilstartdate = format.parse(startdate);     java.util.date utilenddate = format.parse(startdate);     java.sql.date sqlstartdate = new java.sql.date(utilstartdate.gettime());     java.sql.date sqlenddate = new java.sql.date(utilenddate.gettime());       string [] keys = {"title","start","end", "note", "location", "active", "email"};     string [] values = {titel, format.parse(startdate).tostring(), format.parse(enddate).tostring(), note, location, "1", email};     qb.insertinto("calendar", keys).values(values).execute();      return stringtobereturned; } 

however error java.text.parseexception: unparseable date: "22-01-1993" doing wrong

format.parse(startdate).tostring() , format.parse(enddate) trick you.


to add second question.

22-01-1993 how give data.

fri jan 22 00:00:00 cet 1993 how expects it.

so let's change ("dd-mm-yyyy") match it.

("eee mmm dd hh:mm:s zzz yyyy");

that should trick.


apperently not same in php java, updated data (...) match that. information taken

http://docs.oracle.com/javase/7/docs/api/java/text/simpledateformat.html


simpledateformat format = new simpledateformat("eee mmm dd hh:mm:s zzz yyyy");  string startdate = new date().tostring(); 

outputs

fri dec 05 23:15:39 cet 2014 

so works.

the way see don't need following lines

java.util.date utilstartdate = format.parse(startdate); java.util.date utilenddate = format.parse(startdate); java.sql.date sqlstartdate = new java.sql.date(utilstartdate.gettime()); java.sql.date sqlenddate = new java.sql.date(utilenddate.gettime()); 

a problem when having the following input 22-01-1993 doesn't match expected have. extract month, day , year it, build new string rest of data. however, feels redundant.


Comments

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

c# - MSAA finds controls UI Automation doesn't -

wordpress - .htaccess: RewriteRule: bad flag delimiters -