MySQL - setting default timezone for a Rails application

Question

I am using this setup in config/environments/production.rb:

  config.time_zone = 'Eastern Time (US & Canada)'
  config.active_record.default_timezone = 'Eastern Time (US & Canada)'

But when I am deploying the application to the server, I am seeing these warning messages:

warning: :database_timezone option must be :utc or :local - defaulting to :local

How to fix this warning? Should I add another config.active_record.default_timezone with :utc?

Rails cannot use the timezone I set above?

Thank you.

Steven Thomas · Accepted Answer · 2016-06-04 19:07:38Z

2

From: http://guides.rubyonrails.org/configuring.html#configuring-active-record

config.time_zone sets the default time zone for the application and enables time zone awareness for Active Record.

config.active_record.default_timezone determines whether to use Time.local (if set to :local) or Time.utc (if set to :utc) when pulling dates and times from the database. The default is :local.

So based on this, if you want to override your default timezone to Eastern time, you'd want to do:

config.time_zone = 'Eastern Time (US & Canada)'
config.active_record.default_timezone = :local

Let me know if this helps!

answered Jun 4, 2016 at 19:07

Steven Thomas

964 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL - setting default timezone for a Rails application

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related