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 …
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