Best unofficial Apache Server developers community

Answers

How do I set Time.zone to UTC and keep it that way?

⇧

⇩

42 views

I have a Rails 3 application on Ruby 1.9.2 in which users enter business hours and they are stored in a MySQL database. When a user does this, however, the entered time "8:00 AM" gets stored as 3pm in the database. I want it to be stored as they entered it, regardless of time zone. I figured the best way to do this is to set everything to UTC and have it ignore my time zone (Arizona), but Rails seems to be ignoring my setting. Example:

Time.zone = 'UTC'

mon_open_date = Time.parse(params[:venue][:mon_open_at]) rescue nil

# => 2011-04-27 08:00:00 -0700

The result in MySQL:

+-------------+
| mon_open_at |
+-------------+
| 15:00:00    |
+-------------+
1 row in set (0.00 sec)

Any ideas?

mysql ruby-on-rails ruby time

asked April 27, 2011 5:56 am CDT

huertanix

posted via StackOverflow

2 Answers

Newest Most Voted

⇧

⇩

MySQL always uses the server's time zone setting, by default (though you can change that, if you are the database admin).

If you store your date/time values in TIMESTAMP columns, they are stored in a time-zone agnostic manner (being converted to UTC for storage, and then back to the server's time zone again for usage).

If you store your date/times in a DATETIME column, the values are stored exactly as you enter them - if you change the server's time zone, and then SELECT old values out of a DATETIME column, you will see exactly the same values as when you entered them.

Check out the documentation on DATETIME/TIMESTAMP columns for the finer points.

answered May 2, 2011 1:14 am CDT

TehShrike

⇧

⇩

Time.parse always parses the string into your computer's local timezone. You need to use Time.zone.parse in order to parse it as the specified timezone, UTC.

answered May 2, 2011 1:14 am CDT

Beerlington

Your answer

Similar discussion threads

convert in GMT time zone without summer time
April 15, 2011 01:45:26 AM
Hello, I want write a function that converts a timestamp with time zone to the UTC zone. But it should all be stored in the winter time. For example, it must now, in the summer, the German time back by 2 hours and in the winter time only 1 hour.…

time zone confusion?
November 3, 2010 04:25:18 PM
I'm brand new to Mongo, and just started playing with a database set up by somebody else. I did a query with the mongo command-line tool, asking for a field which is a timestamp. The results are shown below. What's strange is that some of the…

Issue Different Time Zone - IVY Repository
January 27, 2011 08:45:34 AM
Hi, I have one query on IVY repository. My Ivy repository is placed in a different time zone (Let's assume United States Central), And I am working in a different time zone (Let's assume India). Now I need to download the latest time stamped jar…

RE: Issue Different Time Zone - IVY Repository
January 28, 2011 02:34:31 AM
Hi Geoff, I imagine your solution should work for Prakash because he has only 1 remote repo in another timezone. But will not be efficient if he had to connect to 2 remote repositories in 2 different timezones from his own timezone. I haven't…

RE: Issue Different Time Zone - IVY Repository
January 28, 2011 07:20:58 AM
Hi I gathered from Prakash's ivysettings.xml that the problem might come from his chain resolver which uses "latest-time" latest strategy : since the chain resolver manages repositories that are not in the same timezone, I imagine it searches for…

A simpler time zone question
March 28, 2011 10:46:48 AM
This is a multi-part message in MIME format. I see that the query "select '2011-11-6 00:59'::timestamptz'" returns a timestamptz with a time zone of -4, which is correct, since I'm in the Eastern time zone and the change from EDT to EST will happen…

Query with time zone offset but without seconds
March 25, 2011 12:40:51 PM
I have a column »timestamp with time zone«. I want to extract the date/time in a different format including the time zone offset in a query but without seconds. If I do select to_char(datetime, 'YYYY-MM-DD HH24:MI') from table; then the time…

Set default time zone for displaying dates in a session
January 28, 2011 04:03:47 AM
Is there a way to set a different time zone as the default for a session? By default, Postgres displays my data stored in "TIMESTAMP WITH TIME ZONE" columns' data as a local time for the time zone of the computer hosting the Postgres cluster. If…

Is TimeZone applied with TIMESTAMP WITHOUT TIME ZONE and Extract( EPOCH ...)?
March 17, 2011 01:24:01 PM
I'm noticing some interesting behavior around timestamp and extract epoch, and it appears that I'm getting a timezone applied somewhere. Specifically, If I do: select EXTRACT( EPOCH FROM '2010-01-31 00:00:00'::TIMESTAMP WITHOUT TIME ZONE ); ==…

why does extract ( HOUR FROM TIMESTAMP '2010-01-01 00:00:00' at time zone 'utc' ) == 16?
March 17, 2011 07:06:23 PM
Is this the correct behavior? It seems like if I specify the utc offset it should be 0, not 16.. It seems to be the opposite behavior from extract epoch. select extract ( HOUR FROM TIMESTAMP '2010-01-01 00:00:00' ) as defhour, extract ( HOUR FROM…

Created] (NET-403) file.getTimestamp(); showing a difference of TIME ZONE RAWOFFSET
April 7, 2011 05:56:45 AM
file.getTimestamp(); showing a difference of TIME ZONE RAWOFFSET

PATCH/puppet-dashboard 1/5] (#4605) Added Time zone setting to settings.yml.
November 15, 2010 12:55:02 PM
From: Paul Berry <pa### @puppetlabs.com> The value specified in settings.yml is optional. If present, it overrides the setting of 'UTC' in config/environment.rb. Paired-with: Matt Robinson <ma### @puppetlabs.com> Signed-off-by: Matt…

PATCH/puppet-dashboard 1/1] (#4401) Modified status query to use the Rails time zone
November 16, 2010 04:56:57 PM
The status query (which we use to generate charts) was using the Time.now and Time.parse methods, which use the system time zone. Changed them to use Time.zone.now and Time.zone.parse, which use the Rails time zone (which we allow the user to…

Updated] (HIVE-345) Extend Date UDFs to support time zone and full specs as in MySQL
April 5, 2011 06:23:04 PM
[ https://issues.apache.org/jira/browse/HIVE-345?page=com.atlassian.jira .plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-345:

Cfengine Help: cf-serverd on local zone dies running cf-agent from global zone
October 7, 2010 05:18:19 AM
Forum: Cfengine Help Subject: cf-serverd on local zone dies running cf-agent from global zone Author: steffenf Link to topic: https://cfengine.com/forum/read.php?3,18649,18649#msg-18649 Hi all! I use solaris 10 on SPARC. I am in the process of…

Created: (HDFS-1307) Add start time, end time and total time taken for FSCK to FSCK report
July 16, 2010 04:40:50 PM
Add start time, end time and total time taken for FSCK to FSCK report

cachedump time is not expiry time... but key set time?
April 6, 2011 07:18:17 PM
Hello, I'm trying to write a tool that will show all the data inside memcached, including expiry times of the keys. However I have run into a big of a snag. It seems that the cache dump expiry times are lying to me - or I'm not understanding what…

can not boot zone
July 28, 2010 01:28:54 PM
On Solaris 10 x86 u7 I get the following error when a zone resource is created: err: //Node[foo]/Zones::Instance[test]/Zone[test]/ensure: change from absent to running failed: Could not boot zone: Execution of '/usr/sbin/ zoneadm -z test boot'…

defrouter in zone resource
July 19, 2010 02:52:05 PM
Does anyone know a way to set the defrouter when creating a zone on a solaris box? I'm guessing the the provider was written before the Solaris update that provided the new functionality. I've been getting around it with an exec (e.g. zonecfg -z…

doing svn up on the zone server (Was: svn commit: r1039238)
November 25, 2010 08:07:17 PM
However i cannot do 'svn up' on the zone server. Do we each need to be in the "forrest" group? -David > Author: crossley > Date: Fri Nov 26 01:56:38 2010 > New Revision: 1039238 > > URL:…

Questions and Answers are licensed under cc-wiki license.

How do I set Time.zone to UTC and keep it that way?

2 Answers

Your answer

Join with account you already have