Converting Times depending on user timezone
I'm trying to create a code that will allow two users to setup a meetup time.
I have one table:
I also have a users table
id - time - meridiem
Some sample data:
1 - 12:00 - A.M
2 - 12:30 - A.M
id - user - timezone
some sample data:
1 - user1 - America/Denver
2 - user2 - America/El_Salvador
If user1 selects 12:00 A.M as the time, I want to convert it to show the correct time in the registered timezone for the second user whenever he views the time that was selected.
Anyone give me any ideas? Thanks so much.