ruby on rails - Get events accoding to user's time zone not DB + Rails4 -

i have 3 events. contains start_time of show.

but problem facing time zone. value saved in db in utc rails default behaviour.

how works: user can select date time date time picker.

as per user, choosed 2017-04-08 04:00:00 ist, event saved in database 2017-04-07 21:30:00 utc.

scenario: when user trying fetch events 8th april, returns nothing because there no events 8th april according database.

in case time zone like:

1) mumbai                       (+05:30) 2) pacific time (us & canada)   (-08:00) 

so in these cases, never correct events according user's time zone.

below events created 8th april saved 7th april whenever user come , see event in calender, never appeared.

<event id: "1250", title: "lgkg", description: nil, created_by: "12345", account_id: "35", repeat: true, start_time: "2017-04-07 21:30:00", created_at: "2017-04-07 05:17:33", updated_at: "2017-04-07 05:17:33">  <event id: "1251", title: "lgkg", description: nil, created_by: "12345", account_id: "35", repeat: true, start_time: "2017-04-07 21:30:00", created_at: "2017-04-07 05:20:43", updated_at: "2017-04-07 05:20:43">  <event id: "1252", title: "lgkg", description: nil, created_by: "12345", account_id: "35", repeat: true, start_time: "2017-04-07 21:30:00", created_at: "2017-04-07 05:25:03", updated_at: "2017-04-07 05:25:03"> 

help:

need find solution fetch events correctly according user's time zone.

required information:

currently account has 1 column time_zone. can use that.

thanks in advance.

i think needed convert datetime utc first:

time.zone = current_account.time_zone utc_time = time.parse(picked_time).utc events = event.where("start_time > ?", utc_time) 

hope helps