Robert, I think what I need to do is convert a DateTime value. stored in the MYSQL db, of 2008-10-31 21:00:00 (UTC) to 2008-10-31 14:00:00 -0700 (AZ time).
Cheers. ** On Fri, Oct 31, 2008 at 4:20 PM, Robert Zotter <[EMAIL PROTECTED]> wrote: > > Charles, > > I am not sure what you want to accomplish. If you want to display the > time you have listed in your database you can always use the > following. > > <%= h evt.start_time.to_s(:db) %> > > Is this what you are looking for? > -- > Robert Zotter > Zapient, LLC > Ruby on Rails Development and Consulting > > http://www.zapient.com > http://www.fromjavatoruby.com > > On Oct 31, 3:17 pm, Charles <[EMAIL PROTECTED]> wrote: > > I'm new to Ruby and have been pulling my hair out trying to figure out > > an issue with displaying DateTime fields. I have programmed a very > > simple app in Windows with a MySQL 5 database. The DateTime fields > > appear to be saved in a UTC format. When displaying DateTime > > information with the following - > > > > <%=h evt.start_time.to_time %> > > > > I see the following output (on Windows) > > > > 2008-10-31 03:00:00 -0700 > > > > In the database the value of the start_time field is - 2008-10-31 > > 10:00:00. It appears "evt.start_time.to_time" is displaying DateTime > > in localtime (MST). > > > > However, the same code on my LINUX (CentOS 5) box yields the following > > output - > > > > 2008-10-31 10:00:00 UTC > > > > What am I missing? I've verified time, timezone and NTP settings on > > the LINUX box. > > > > I have the following setup in my environment.rb - > > > > config.time_zone = 'Arizona' > > > > I'm at a complete loss. Any help would be greatly appreciated. > > > > C > > > --~--~---------~--~----~------------~-------~--~----~ 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
