On Wed, Feb 15, 2012 at 7:47 PM, art tav <[email protected]> wrote:
> Hi, > > My doubt is about how to make request to mysql using a different time > than utf with this I try to say something like this > > User request for registers from 2012-02-13, his timezone is cst. > > Mysql works with utc so if a register was created after 6 p.m cst time > it will be saved with the date like 2012-02-14 00:10:... so I'm > wondering what I can do to show the user all the registers created in > the date he asked depending in the timezone he is working. > You may consider using a real "Date" object to store a date ... > require 'date' > Date.today.to_s #=> "2012-02-15" I made the mistake once to use Time (DateTime actually) to store a real "date" and it continued to create difficulties with different timezones etc. (not because of the language, but because of the "real life" issue that a contract starts at a certain _date_ and this is in reality a different time depending on the Time Zone). If you still can change it to a real date format in the database column, consider it seriously. HTH, Peter -- *** Available for a new project *** Peter Vandenabeele http://twitter.com/peter_v http://rails.vandenabeele.com http://coderwall.com/peter_v -- 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.
