java - conversion to GMT giving problems during DST -


i facing problem in our existing application time entered employee (from org/store using time clock application) first converted gmt , stored in db. , displaying back, time in gmt converted store local time zone , displayed. in of cases works fine not when time zone moves dst , vice versa.

let me more specific. suppose standard time zone of store gmt-8 , employee punches @ 08:00 in morning, time converted gmt gives 16:00 , stored in db. conversion process first converts 08:00 store local time somehow gives 17:00 cet , 17:00 cet converted gmt gives 16:00 cet.

but if take example of 31 march when dst happens 02:00 becomes 03:00 am. suppose emplyoee punches @ 18:00 (on 30 march) returns me 04:00 cest during first conversion local , when convert gmt gives 03:00 cest. while converting gives 19:00 not correct. design says local times converted utc , stored in db if still utc should store 02:00 , not 03:00 because gmt/utc not have dst.

the code used conversion is:

step 1

final date localpunchdatetime = r3valconverter.convertfromtimezone(tedata.m_dttm,                                                  timezone.gettimezone("gmt-8"));

step 2

tedata.m_dttm = r3valconverter.converttogmt( localpunchdatetime );

r3valconverter.java

public static date convertfromtimezone(final date dtsrc, final timezone tzsrc)     {          final sisdatetime dttmtemp = new sisdatetime(dtsrc, timezone.getdefault());         final sisdatetime dttmsrc = new sisdatetime( dttmtemp.getyear(), dttmtemp.getmonth(),                                                       dttmtemp.getdate(), dttmtemp.gethour(),                                                       dttmtemp.getminute(), dttmtemp.getsecond(),                                                       tzsrc );          return dttmsrc.todate();                                                            }

sisdatetime

gregoriancalendar m_cal;  public sisdatetime(date dt, timezone tz) throws sisdatetimeexception     {          m_cal = new gregoriancalendar(tz);         m_cal.settime(dt);         resetmillis();     }

the other sisdatetime method using same gregoriancalendar.

i appreciate in regard. assuming here have problem here in first step dont know solution @ moment.

you have store utc + current offset in seconds local time utc in db. if want preserve local time, need pair (utc time, offset)

you use timezonewithoffsetfromgmt (or simmiliar named)


Comments

Post a Comment

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

running rails generate controller foo home results in: class foocontroller < application controller def home end end (there's nothing on line in actual file, blank line) is there purpose blank line? it's common use newline indicate end of line, last line. many editors (like vi, use) add in newline silently. consensus text files (especially in unix world) should end in newline, , there have been problems historically if wasn't present. why should text files end newline? the tool used count lines in file "wc" counts newlines in file, without trailing newline show 3 instead of 4. it improves readability of templates used in generator. consider: https://github.com/rails/rails/blob/master/railties/lib/rails/generators/rails/controller/templates/controller.rb to remove trailing newline, template have last line of: end<% end -%> instead of: end <% end -%> that seems less readable me. the discussion below refers ...
Read more

keyboard - Smiles and long press feature in Android -

i've created android keyboard. how add features inserting smilies, , using long keypresses display symbols? to create long-press behavior allows select several options pop-up menu, follow guide (specifically pop-up menu section): http://developer.android.com/guide/topics/ui/menus.html smileys (also known emoticons) combination of keys, understood programs , parsed same way. have do, when clicks smiley face on keyboard, simulate pressing of key combination matching emoticon. example, when clicks smiley, should simulate key presses ':' , ')' :). here's list of emoticons: http://en.wikipedia.org/wiki/list_of_emoticons
Read more

node.js - Bad Request - node js ajax post -

i'm using express 3.0 , node v0.11.0. have button submits form , i'm using ajax post data json object node server. client code is: $('#contact').submit(function(e) { console.log('submit called'); var formdata = json.stringify($('form').serializeobject()); console.log(formdata); $.ajax({ url: "http://localhost:3000/savedata/", type: "post", datatype: 'json', data: {objectdata: formdata}, contenttype: "application/json", complete: function() { console.log('process complete'); }, success: function(data) { console.log('process sucess'); }, error: function() { console.log('process error'); }, }); return false; }); then on server: var express = require('express'); var app = express(); app.set('views', __dirname + '/views'); app.set('view engine', 'jade'); app.use(express.bodyparser());...
Read more