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.
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.
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.
Well then you really suggest that I change the datetime format for a
date format to deal with this issue? The time is used for knowing
exactly when the transaction was made and we really need this
information... but for purposes of searching and retrieving the
information of the db may be I can create a new date field hmmm
Well I think something like that would be the most elegant and simple
solution because doing other things that I've been thinking about will
require a lot of complex work and that could be bad solution in the end.