I am using rails 3.0.5 and I have created_at and updated_at stored in UTC. Now I want to display the created_at time in users' timezone. I believe it is possible to pick user's timezone from the browser and then convert time to user's timezone.
I am sure rails will have a gem/plugin to take care of something like this. Is there something?
You can set any specific time zone using the PHP function date_default_timezone_set . This sets the specified time zone for users. Basically the users' time zone is goes to the client side, so we must use JavaScript for this. Below is the script to get users' time zone using PHP and JavaScript.
CURRENT_TIMESTAMP returns the current date and time in the session time zone, in a value of datatype TIMESTAMP WITH TIME ZONE . The time zone offset reflects the current local time of the SQL session. If you omit precision, then the default is 6.
The user time zone is a client-specific time zone that can be defined for the user time and user date of each individual user in the user master record. It is contained in the system field sy-zonlo.
Rails by default converts every date into UTC before storing the value into the database. This means that, regardless the server timezone, you always have UTC dates in your database.
In order to convert the dates into your user's timezone you have basically two possibilities:
If your site allows registration, you can store the user timezone as user preference. In the user table, store the user timezone. Then create a custom helper you can use to format any date/time into the proper timezone using the in_time_zone
method.
> t = Time.current # => Mon, 23 Dec 2013 18:25:55 UTC +00:00 > t.zone # => "UTC" > t.in_time_zone("CET") # => Mon, 23 Dec 2013 19:25:55 CET +01:00
Your helper may looks like
def format_time(time, timezone) time.in_time_zone(timezone) end
I normally also like to output a standard format, using the I18n.l
helper
def format_time(time, timezone) I18n.l time.to_time.in_time_zone(timezone), format: :long end
If your site has no registration or you don't want to ask your users for their timezone or you simply want to use the user system timezone, then you can use JavaScript.
My suggestion is to create a custom helper that will print out every time in a proper way so that you can create a generic JavaScript function to convert the values.
def format_time(time, timezone) time = time.to_time content_tag(:span, I18n.l(time, format: :long), data: { timezone: timezone, time: time.iso8601 }) end
Now, create a JavaScript function that is performed on DOM load and that will select all the HTML tags with data-time
attribute. Loop them and update the value inside the span
tag with the proper time in the given timezone.
A simple jQuery example would be
$(function() { $("span[data-time]").each(function() { // get the value from data-time and format according to data-timezone // write the content back into the span tag }); });
I'm not posting the full code here, since there are plenty of JavaScript time formatters available with a simple search. Here's a few possible solutions
There is a nice gem by Basecamp called local_time for client side rendering - https://github.com/basecamp/local_time. It's great for applications where user is not signed in and it's caching friendly.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With