i tying cast datetime
sql server timestamp got error don't know did wrong. know how solve this? :
this java/android error :
fatal exception: main process: abtech.waiteriano.com.waitrer, pid: 29858 java.lang.classcastexception:
java.sql.timestamp cannot cast net.sourceforge.jtds.jdbc.datetime
i have timestamp "2017-04-05 19:37:47:54"
, value cannot casted above error java datetime
object.
and error originates part of c# code (in sql server database) :
systime = (((datetime) dtchecks.get("openin").get(0)).totime().gethours() * 60) + ((datetime) dtchecks.get("openin").get(0)).totime().getminutes();
the value of systime
date "2017-04-05 19:37:47.54". retrieved making toast...
toast.maketext(context,dtchecks.get("openin").get(0) + "", toast.length_long).show();
if can timestamp c# java , have (cast) java string
code example code should :
first declare variables :
static date myjavadate; //create (java) date object static dateformat dateform; //will setup match incoming c# time format static string str_ts; //string holds c# timestamp
then in main part of code :
//# set match incoming time/date format dateform = new simpledateformat("yyyy-mm-dd hh:mm:ss:sss"); //# set input timestamp date convert str_ts = "2017-04-05 19:37:47:54"; //srt_ts = c_sharp_timestamp.tostring(); //untested //# convert via function check result myjavadate = convertstringtodate(str_ts); system.out.println("myjavadate : " + myjavadate);
below supporting convertstringtodate
function :
public static date convertstringtodate(string input) { try { date date = (date) dateform.parse(input); return date; } catch (parseexception exc) { system.out.println("date converting error : " + exc); return null; } }
checking println
result, should :
myjavadate : wed apr 05 19:37:47 utc 2017
note: notice simpledateformat("yyyy-mm-dd hh:mm:ss:sss")
has required -
, :
symbols , space
@ correct positions match exact same style of c# timestamp format? aware if part wrong fails convert date
... for example : if string 05/04/2017...
declare ("dd/mm/yyyy...
, on success.
also sss
milliseconds date
ignores part anyway.
Comments
Post a Comment