java - How to convert Joda DateTime to UTC MySql timestamp -


i have joda datetime object representing utc time, , wish store in timestamp field in mysql table.

i have following code:

string ztime = "2013-10-07t08:00:00z";    datetimeformatter parser = isodatetimeformat.datetimeparser(); datetime dt = parser.parsedatetime(ztime).withzone(datetimezone.utc);  preparedstatement stmt = con.preparestatement("insert time_test (time) values (?)"); stmt.settimestamp(1, timestamp(dt.getmillis())); stmt.execute();

however, when in database, time gets store out difference of database's timezone utc. e.g. when database running in utc+1, , run above code save "08:00z", in database timestamp shows 09:00.

datetime's getmillis method says " gets milliseconds of datetime instant java epoch of 1970-01-01t00:00:00z." , mysql's timestamp says: "mysql converts timestamp values current time zone utc storage, , utc current time zone retrieval.", presume it's mysql conversion that's causing issue, because millis it's being initialized relative fixed utc time, has no need convert current time zone utc.

my code read data out datetime works fine, , value out put in, need work 3rd-party code on have no control, expects timestamp in correct utc time.

how timestamp field in database match original utc date/time ?


Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more