The idea is php.ini has its default.timezone = ‘UTC’. By default once mySQL is running it is internally define its global timezone = ‘SYSTEM’ which I understand follow the php.ini definition of timezone. It is also mention in Mariab and mySQL that it saves the DateTime in UTC timezone in order for the database to adapt when you change the default.timezone. I was thinking of using session variable as part of the login [glo_timezone] whic being redefine by each user login on the system , but somewhere in the documentation it is also dependent in the connection and since when scriptcase application is deploy their is only one connection and so this may not work.
Digging and come up with the DateTime object and running in blank application seems works, the question is if I’m using the forms with database table having DateTime field it does not work and keep the field blank. I also saw in previous forum of form application in the part of sql preparation to have SET time_zone = [glo_timezone] if it works then how to use with Grid application for there is no part SQL preparation.
Does Anyone has done it ? , please share knowledge of englightenment, thanks