Hi there, I''m fairly new to RoR, and I seem to be having a problem with :time types. I save my times with a time_select on my form, to a time type field on MySQL. Rails automatically pulls it back to UTC from my timezone (+02:00), but when I display it again, it stays at the UTC value, i.e. I enter in 6:30, and I get 4:30 on my list. Is it just me, or is this a limitation of the time datatype in mysql, obviously all the datetime conversions work perfectly, like in my timestamps... Any help would be greatly appreciated. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Thu, Sep 11, 2008 at 10:42 AM, Stuart Corbishley <corbish-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote:> > Hi there, > > I''m fairly new to RoR, and I seem to be having a problem with :time > types. > > I save my times with a time_select on my form, to a time type field on > MySQL. > > Rails automatically pulls it back to UTC from my timezone (+02:00), > but when I display it again, it stays at the UTC value, i.e. I enter > in 6:30, and I get 4:30 on my list. > > Is it just me, or is this a limitation of the time datatype in mysql, > obviously all the datetime conversions work perfectly, like in my > timestamps... > > Any help would be greatly appreciated. >Hi, what''s goal or what are you trying to accomplish? Where''s a list of actions that you performed in script/console? Please provide some code snippets if you can. -Conrad --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On 11 Sep 2008, at 18:42, Stuart Corbishley wrote:> > Hi there, > > I''m fairly new to RoR, and I seem to be having a problem with :time > types. > > I save my times with a time_select on my form, to a time type field on > MySQL. > > Rails automatically pulls it back to UTC from my timezone (+02:00), > but when I display it again, it stays at the UTC value, i.e. I enter > in 6:30, and I get 4:30 on my list.Related to http://rails.lighthouseapp.com/projects/8994/tickets/1030-multiparameter-attributes-incorrectly-do-time-zone-conversion-on-time-only-columns maybe ? Fred> > > Is it just me, or is this a limitation of the time datatype in mysql, > obviously all the datetime conversions work perfectly, like in my > timestamps... > > Any help would be greatly appreciated. > > >--~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---