Check out example codes for "convert_tz mysql". It will help you in understanding the concepts better.

Code Example 1

CONVERT_TZ(datetime, from_tz, to_tz)

Example: 
SELECT CONVERT_TZ('2031-09-21 02:42:14', 'UTC', 'America/New_York');
output: 2031-09-20 22:42:14

Learn ReactJs, React Native from akashmittal.com