getTime() returns the number of milliseconds since the epoch, not the number of seconds: http://www.w3schools.com/jsref/jsref_gettime.asp
If you divide that number by 1000, it should work. On Mon, Apr 30, 2012 at 11:28 AM, samal <samalgo...@gmail.com> wrote: > 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/> >> >> > -- Tyler Hobbs DataStax <http://datastax.com/>