Hello,
I'm using Rail 2.3.2 and I want to include time zones with my
application by putting:
config.time_zone = "Pacific Time (US & Canada)"
in my environment.rb.
This works fine on my Mac development machine but I move to production
it gets messed up...For instance I have a condition as follows:
:conditions => ['(effective_end_date IS NULL OR effective_end_date > ?)
AND (effective_start_date IS NULL OR
effective_start_date < ?) ',Time.now.gmtime, Time.now.gmtime]
Which works fine on development as mentioned earlier by looking at
queries but on production I got something like this
SELECT * FROM `sms_messages` WHERE (`sms_messages`.user_id = 1 AND
(created_at > '2009-04-05 05:18:23' and status != 'SCHEDULED_MESSAGE'))
AND (((effective_end_date IS NULL OR effect
ive_end_date > '2009-05-03 03:19:57')
AND (effective_start_date IS NULL OR effective_start_date < '2009-05-03
03:19:57') ) AND (`sms_messages`.user_id = 1)) ORDER BY created_at DESC
But when I try to fetch time form IRB:
>> Time.now
=> Mon May 04 22:24:27 -0700 2009
>> Time.now.gmtime
=> Tue May 05 05:24:34 UTC 2009
Which seems correct!!!! It's like as if instead of adding 7 hours to get
the UTC time it negates 7 hours from the current time!
Not sure if I have to do extra setting for production machine.
Any ideas how to go about finding what the problem is?
Thanks,
Tam
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
