I did it with node.js but it is changing after some interval. <code> setInterval(function(){ var d =new Date().getTime(); console.log("====================== "); console.log("unix => ",d); i=parseInt(d) console.log("Divid i/86400=> ",i/86400); console.log("Modulo i%86400=> ",i%86400); console.log("====================== "); },2000);
</code> Am I doing wrong? On Mon, Apr 30, 2012 at 9:54 PM, Tyler Hobbs <ty...@datastax.com> wrote: > Correct, that's exactly what I'm saying. > > > On Mon, Apr 30, 2012 at 10:37 AM, samal <samalgo...@gmail.com> wrote: > >> thanks tyler for reply. >> >> are you saying user1uuid_*{ts%86400}* would lead to unique day bucket >> which will be timezone {NZ to US} independent? I will try. >> >> >> On Mon, Apr 30, 2012 at 8:25 PM, Tyler Hobbs <ty...@datastax.com> wrote: >> >>> Don't use dates or datestamps as the buckets for your row keys, use a >>> unix timestamp modulo whatever size you want your bucket to be instead. >>> Timestamps don't involve time zones or any of that nonsense. >>> >>> So, instead of having keys like "user1uuid_30042012", the second half >>> would be replaced the current unix timestamp mod 86400 (the number of >>> seconds in a day). >>> >>> >>> On Mon, Apr 30, 2012 at 1:46 AM, samal <samalgo...@gmail.com> wrote: >>> >>>> Hello List, >>>> >>>> I need suggestion/ recommendation on time series data. >>>> >>>> I have requirement where users belongs to different timezone and they >>>> can subscribe to global group. >>>> When users at specific timezone send update to group it is available to >>>> every user in different timezone. >>>> >>>> I am using GroupSubscribedUsers CF where all update to group are push >>>> to "Each User" time line, and key is timelined by useruuid_date(one day >>>> update of all groups) and columns are group updates. >>>> >>>> GroupSubscribedUsers ={ >>>> user1uuid_30042012:{//this user belongs to same timezone >>>> timeuuid1:JSON[group1update1] >>>> timeuuid2:JSON[group2update2] >>>> timeuuid3:JSON[group1update2] >>>> timeuuid4:JSON[group4update1] >>>> }, >>>> user2uuid_30042012:{//this user belongs to different timezone where >>>> date has changed already to 1may but 30 april is getting update >>>> timeuuid1:JSON[group1update1] >>>> timeuuid2:JSON[group2update2] >>>> timeuuid3:JSON[group1update2] >>>> timeuuid4:JSON[group4update1] >>>> timeuuid5:JSON[groupNupdate1] >>>> }, >>>> >>>> } >>>> >>>> I have noticed this approach is good for single time zone when >>>> different timezone come into picture it breaks. >>>> >>>> I am thinking of like when user pushed update to group ->get user who >>>> is subscribed to group->check user timezone->push time series in user time >>>> zone. So for one user update will be on 30april where as other may have on >>>> 29april and 1may, using timestamps i can find out hours ago update came. >>>> >>>> Is there any better approach? >>>> >>>> >>>> Thanks, >>>> >>>> >>>Samal >>>> >>>> >>>> >>> >>> >>> -- >>> Tyler Hobbs >>> DataStax <http://datastax.com/> >>> >>> >> > > > -- > Tyler Hobbs > DataStax <http://datastax.com/> > >