How can I change the timezone in MySQL?
You would use the CONVERT_TZ function like this:

SELECT CONVERT_TZ('2012-01-01 12:00:00','-06:00','+00:00')


Example SQL Fiddle

But, why are you using varchar for your date/time fields? It would be better to use the proper data types DATE and TIME.