1
2
3
4
5
require 'net/http'
require 'Date'
txt = '2020-07-21 16:30' # or txt = '202007211630'
ts = DateTime.parse(txt) 
#=> #<DateTime: 2020-07-21T16:30:00+00:00 ((2459052j,59400s,0n),+0s,2299161j)>

You’ll notice that we get this:

#<DateTime: 2020-07-21T16:30:00+00:00 ((2459052j,59400s,0n),+0s,2299161j)>

It correctly parses the time stamp but the time zone is set to UTC since there was no time zone specified. For me, this is wrong since the string refers to a time stamp in the Singapore zone (UTC+8). However, it is surprisingly difficult to change the time zone of a DateTime object. You can’t just set change the zone or the offset from UTC. Support is better in Rails (of course!). It’s best to use something from Rails since it takes care of problems with time zones such as Daylight Saving Time and so on. Fortunately, Singapore is simple since we are on the equator and don’t have any issue with Daylight Saving Time.

If you don’t want to use help from Rails in your Ruby code, there seem to be two ways to handle this:

• Once you get the DateTime object, you can subtract the number of hours from it to convert the time into UTC and then the UTC time zone is correct. This is done by hours/24 being subtracted from the timestamp you have. (note: it’s important to have it as a floating point number such as 8.0, 7.5 or such so that integer division does not happen)
  

  1
  2
  3
  4
  5
  6
  7
  require 'net/http'
  require 'Date'
  txt = '2020-07-21 16:30' # or txt = '202007211630'
  ts = DateTime.parse(txt)
  #=> #<DateTime: 2020-07-21T16:30:00+00:00 ((2459052j,59400s,0n),+0s,2299161j)>
  ts = ts - (8.0/24) 
  #=> #<DateTime: 2020-07-21T08:30:00+00:00 ((2459052j,30600s,0n),+0s,2299161j)>
  

  
  
• The other alternative is to not use Date.parse and add the time zone to the string itself – this is described next

Adding the Time Zone

If you have a string such as 2020-07-21 16:30+08:00 with the timezone embedded in the string, actually DateTime.parse does a great job with it and will correctly set the timezone for the timestamp. So, the first option is to treat your string to be str + '+08:00' and then get DateTime.parse to work with that.

However, if you have it as 202007211630 and add the time zone to it so that you get 202007211630+08:00, the complexity of the input is too much for parse and it ignores the timezone suggestion. You still get the same data and with timezone set to UTC. This is where it helps to go to the not-so-sexy but super-reliable strptime method instead. The DateTime.strptime method allows you to specify the format of the input string while parsing the string (it’s basically like strftime but much less frequently used).

Here’s what we will do:

• Take the text and add ‘+08:00’
• Parse it using strptime with the format specified for it (the format directives are in the Ruby documentation)

1
2
3
4
5
6
7
8
require 'net/http'
require 'Date'
time = '202007211630'
dtxt = time + "+08:00" # force add the time zone for SGT

# using strptime to force read the time zone in SGT
ts = DateTime.strptime(dtxt, "%Y%m%d%H%M%z") 
#=> #<DateTime: 2020-07-21T16:30:00+08:00 ((2459052j,30600s,0n),+28800s,2299161j)>