Convert a date or time from one timezone to another in MySQL.

select CONVERT_TZ(mydatefield, 'US/Pacific', 'CET') from mytable;