Rails 3 Timezone error

Posted by Juan on Stack Overflow See other posts from Stack Overflow or by Juan
Published on 2010-05-31T14:02:07Z Indexed on 2010/06/03 9:44 UTC
Read the original article Hit count: 233

Filed under:

timezone

|

ruby-on-rails3

I am struggling with time zone support in Rails 3 beta and I would like to know if it is a bug or if I am doing something wrong. He is the problem:

> Time.zone = 'Madrid'  # it is GMT+2
 => "Madrid" 
> c = Comment.new
 => #<Comment id: nil, title: "", pub_at: nil>
> c.pub_at = Time.zone.parse('10:00:00')
 => Mon, 31 May 2010 10:00:00 CEST +02:00 
> c.save
> c
 => #<Comment id: 3, title: "", pub_at: "2010-05-31 08:00:00">
> c.reload
 => #<Comment id: 3, title: "", pub_at: "2010-05-31 08:00:00">
ruby-1.8.7-p249 > c.pub_at
 => Mon, 31 May 2010 13:00:00 CEST +02:00

As you can see, the pub_at attribute is stored correctly in the database but when it is retrieved it adds 3 hours and I suspect that it is because it is using my local machine timezone that is in GMT-3.

The same sequence of commands in rails 2.3.5 works perfectly.

Any toughts? Should I report a ticket?

© Stack Overflow or respective owner

Related posts about timezone

PostgreSQL timezone does not match system timezone

as seen on Server Fault - Search for 'Server Fault'
I have several PostgreSQL 9.2 installations where the timezone used by PostgreSQL is GMT, despite the entire system being "Europe/Vienna". I double-checked that postgresql.conf does not contain timezone setting, so according to the documentation it should fallback to the system's timezone. However… >>> More
.NET Get timezone offset by timezone name

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, In database I store all date/times in UTC. I know user's timezone name ("US Eastern Standard Time" for example). In order to display correct time I was thinking that I need to add user's timezone offset to UTC date/time. But how would I get timezone offset by timezone name? Thank You! >>> More
Building TimeZone object in Java

as seen on Stack Overflow - Search for 'Stack Overflow'
I build a Java TimeZone object using the TimeZone String like GMT-8,GMT,PST,EST etc. This did not consider whether the timezone is daylight saving enabled or not.Now there is a requirement to include this check and instead of giving the input as PDT or EDT the daylight saving is given as a seperate… >>> More
Running Webapp on Mac in UTC (either changing MacBook timezone or tomcat timezone)

as seen on Super User - Search for 'Super User'
To run my web app, I need to set my timezone to UTC on my MacBook. I can do this temporarily by opening a Konsole and entering sudo ln -sf /usr/share/zoneinfo/UTC /etc/localtime However, my timezone returns to normal when I restart my machine! Any advice? Edit : The response to this question… >>> More
Setting session timezone with spring jdbc oracle

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello I have a spring/jdbc/oracle 10g application. The Oracle server database timezone is set to GMT + 2 JVM timezone is GMT + 2 (even though it doesn't matter in my case). I have a stored procedure that performs some date operations. The problem is that session timezone is different(GMT) than database… >>> More

Related posts about ruby-on-rails3

ruby-on-rails3, and select distinct using activereccord3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, Some methods have been deprecated with Rails3. It is the case in particular with the following call ! Error.find(:all, :select => 'DISTINCT type') Is anybody have an idea, how to convert this call to an ActiveRecord3 valid statement ? I found nothing on the web ... Thanks >>> More
Rails3 server and bundler error: uninitialized constant Bundler (NameError)

as seen on Stack Overflow - Search for 'Stack Overflow'
I just install rails 3 and all gems that it need, but when I try to start server, it says about problem in boot script. [rap-kasta@acerAspire testR3]$ script/rails server /home/rap-kasta/tmp/testR3/config/boot.rb:7:in `rescue in <top (required)>': uninitialized constant Bundler (NameError)… >>> More
How to set ActiveModel::Base.include_root_in_json to false?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Rails 3 w/ Mongoid, (so no ActiveRecord). Mongoid uses ActiveModel's "to_json" method, and by default that method includes the root object in the JSON (which I don't want). I've tried putting this in an initializer: ActiveModel::Base.include_root_in_json = false But get the error uninitialized… >>> More
No such file to load bundler error for Rails 3

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Rails 3 app ready for staging. I haven't got a VPS host set up yet. As I was planning to have everything on shared host for the first few months. Problem: cd myapp bundle check result: The Gemfile's dependencies are satisfied Passenger error: Error message: no such file to load… >>> More
How to test Rails 3 Engines with Cucumber & Rspec?

as seen on Stack Overflow - Search for 'Stack Overflow'
I apologize if this question is slightly subjective... I am trying to figure out the best way to test Rails 3 Engines with Cucumber & Rspec. In order to test the engine a rails 3 app is necessary. Here is what I am currently doing: Add a rails test app to the root of the gem (myengine) by… >>> More