You can do (Time.now - Time.mktime(*ParseDate.parsedate((t.created_at).to_s)))
On Wed, Aug 29, 2012 at 12:18 PM, keerthi <[email protected]>wrote: > @colin here i found in console > > >> @bio = Biometric.find(36457) > => #<Biometric id: 36457, rfid: 0, userid: 3, date_time: "2012-08-29 > 09:30:00", checkin_checkout: nil, forget: nil, reason: nil, entered_by: > nil, created_at: "2012-08-29 09:30:00", updated_at: "2012-08-29 09:30:00", > RealCheckIn: nil, MACHINENO: nil> > >> @first = @bio.date_time.to_i > => 1346232600 > >> @now = Time.now > => Wed Aug 29 12:13:46 +0530 2012 > >> @time_now = @now.to_i > => 1346222626 > >> @time_now - @first > => -9974 > > @first = @bio.date_time > => Wed, 29 Aug 2012 09:30:00 UTC +00:00 > with out converting to to_i > > >> @now = Time.now > => Wed Aug 29 12:16:48 +0530 2012 > with out converting to_i > > as i found was my date from database is in UTC format and when it comes to > Time.now its not UTC > > > how can i solve it > > Cheers > > > > > On Tue, Aug 28, 2012 at 9:28 PM, Colin Law <[email protected]> wrote: > >> On 28 August 2012 16:40, sameena Khan <[email protected]> >> wrote: >> > @colin if i have two timings9:30 PM and 10:52 i got correct output >> here it >> > is 10 hours : 38mins >> > and if i give Time.now as one input and 10:30 AM as another input i >> got 2 >> > hours : mins >> >> The best thing is to put in some diagnostic code and work out what is >> happening. Remember Time.now is not a time of day it is a date and >> time. Hopefully your other times are also full date and time objects. >> >> Colin >> >> > >> > >> > i dont think it is timezone issue because if there are two fixed inputs >> and >> > if i subtract them with my code i get the correct output the only issue >> is >> > with Time.now as a input i guess. i wanna calculate the working hours >> with >> > mins of an employee. As i explained before if the employee checkin and >> > checkout time is there i can able to calculate it and if i wanna show >> right >> > from his checkin until he checkout every min of his working hours and >> mins i >> > have to go for Time.now as another input. >> > >> > On Tue, Aug 28, 2012 at 8:05 PM, Colin Law <[email protected]> >> wrote: >> >> >> >> On 28 August 2012 15:18, Khan <[email protected]> wrote: >> >> > Hey everyone >> >> > >> >> > i am trying to subtract two different times.i am getting >> >> > right >> >> > when i have two fixed times. >> >> > here is my code >> >> > >> >> > >> >> > def hour_min(last,first) >> >> > >> >> > difference = last - first >> >> > seconds = difference % 60 >> >> > difference = (difference - seconds) / 60 >> >> > minutes = difference % 60 >> >> > difference = (difference - minutes) / 60 >> >> > hours = difference % 24 >> >> > >> >> > return hours,minutes >> >> > >> >> > end >> >> > if last =9:30 PM and first = 10:52 i get after subtraction 10 hours >> : 38 >> >> > mins but the problem is with Time.now >> >> > if last = Time.now and first = 10:30 am it is give improper output >> >> > >> >> > >> >> > >> >> > this is my view >> >> > <% hour_min = hour_min(Time.now.to_i,cin.first.to_i)%> >> >> >> >> You should not need to call to_i, just pass in the times, the >> >> difference of two times is the difference in seconds. >> > >> > >> > If i don't call with to_i the output will be with decimal(i.e., 3.o >> hours ) >> > to convert them i went with to_i >> >> >> >> >> >> > <%="#{hour_min[0]}Hour : #{hour_min[1]}Min"%> >> >> > >> >> > My problem is if i have two fixed timings i am getting correct but >> when >> >> > i >> >> > have to calculate with Time.now i am getting wrong answer can any one >> >> > help >> >> > me out >> >> >> >> Have a look at the Rails Guide on debugging which will show you >> >> techniques that can be used to debug the code. I would start just by >> >> running the console (rails c) and try calling your method with various >> >> values and see what happens. You can use puts in the method to print >> >> intermediate results and see what is happening. >> >> >> >> What results are you getting? Is it a number of hours out? If so >> >> then I guess it is a time zone issue. >> >> >> >> Colin >> >> >> >> -- >> >> You received this message because you are subscribed to the Google >> Groups >> >> "Ruby on Rails: Talk" group. >> >> To post to this group, send email to [email protected] >> . >> >> To unsubscribe from this group, send email to >> >> [email protected]. >> >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> >> > >> > -- >> > You received this message because you are subscribed to the Google >> Groups >> > "Ruby on Rails: Talk" group. >> > To post to this group, send email to [email protected]. >> > To unsubscribe from this group, send email to >> > [email protected]. >> > For more options, visit https://groups.google.com/groups/opt_out. >> > >> > >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
