MySQL: timezone
MySQL has system timezone, global timezone and session timezone (also call as per request timezone).
System timezone is current machine's timezone.
Global timezone and session timezone default value is system timezone.
When user insert a value to timestamp column (we call "date1"), MySQL suppose date1 as session timezone and convert to global timezone then save to DB.
When user select timestamp column, MySQL will convert from global timezone to session timezone than return value.
System timezone is current machine's timezone.
Global timezone and session timezone default value is system timezone.
When user insert a value to timestamp column (we call "date1"), MySQL suppose date1 as session timezone and convert to global timezone then save to DB.
When user select timestamp column, MySQL will convert from global timezone to session timezone than return value.