Setting local date on Scriptcase Hosted MYSQL trigger event

I use Scriptcase Host for a MYSQL database.
I created triggers to log insert, update and delete events on a couple of tables.
In the trigger I have used NOW() to log the datetime.
BUT, the date defaults to the server time. How can I code it to my local time zone?
Regards Doug Maclean