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,
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
client can change its own time zone with this statement: