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

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