For Tim & Marley with Love :-)

yay-time.sql

SELECT
    DATABASE(), table_name, column_name, data_type,
    CONCAT(
        "UPDATE ", table_name,
        " SET ", column_name, " = CONVERT_TZ(", column_name, ", 'UTC', 'Australia/Sydney')",
        " WHERE ", column_name, " > '2014-08-05 22:00:00';"
    ) AS query
FROM information_schema.columns
WHERE
    table_schema = DATABASE()
    AND data_type IN ('datetime')
    AND NOT (
        (table_name = 'reviewlog'              AND column_name = 'reviewDate')   OR
        (table_name = 'incidentlog'            AND column_name = 'incidentDate') OR
        (table_name = 'externalSurvey_log'     AND column_name = 'reviewDate')   OR
        (table_name = 'notice'                 AND column_name = 'expiryDate')   OR
        (table_name = 'applicationsinterviews' AND column_name = 'interviewDateTime')
    )
ORDER BY table_name, column_name
;

SELECT
    DATABASE(), table_name, column_name, data_type,
    CONCAT(
        "UPDATE ", table_name,
        " SET ", column_name, " = CONVERT_TZ(", column_name, ", 'Australia/Sydney', 'UTC')",
        " WHERE ", column_name, " > '2014-08-05 22:00:00';"
    ) AS query
FROM information_schema.columns
WHERE
    table_schema = DATABASE()
    AND data_type IN ('timestamp')
ORDER BY table_name, column_name
;