I want to change mysql default timezone to UK timezone,
I have no access to mysql config file. Is there any way that I can do this on query level.
So once the query executed then it will save date based on Uk timezone,
client can change its own time zone with this statement:
In the configuration file you are loading you can set the timezone with the default-time-zone='timezone' directive e.g.
for UTC. There is more information in the MySQL timezone reference manual
To change your timezone on the fly use the