Magento: Convert timezone to or from AWS to local timezone

#Convert local timezone DB to AWS
UPDATE customer_entity SET created_at = CONVERT_TZ(created_at,'-10:00','UTC'), updated_at = CONVERT_TZ(updated_at,'-10:00','UTC');
UPDATE sales_flat_order SET created_at = CONVERT_TZ(created_at,'-10:00','UTC'), updated_at = CONVERT_TZ(updated_at,'-10:00','UTC');
UPDATE sales_flat_order_grid SET created_at = CONVERT_TZ(created_at,'-10:00','UTC'), updated_at = CONVERT_TZ(updated_at,'-10:00','UTC');
UPDATE sales_flat_invoice SET created_at = CONVERT_TZ(created_at,'-10:00','UTC'), updated_at = CONVERT_TZ(updated_at,'-10:00','UTC');
UPDATE sales_flat_invoice_grid SET created_at = CONVERT_TZ(created_at,'-10:00','UTC'), order_created_at = CONVERT_TZ(order_created_at,'-10:00','UTC');
UPDATE sales_flat_shipment SET created_at = CONVERT_TZ(created_at,'-10:00','UTC'), updated_at = CONVERT_TZ(updated_at,'-10:00','UTC');
UPDATE sales_flat_shipment_grid SET created_at = CONVERT_TZ(created_at,'-10:00','UTC'), order_created_at = CONVERT_TZ(order_created_at,'-10:00','UTC');

#Convert AWS (UTC) DB to local timezone

UPDATE sales_flat_order SET created_at = CONVERT_TZ(created_at,'+10:00','+00:00'), updated_at = CONVERT_TZ(updated_at,'+10:00','+00:00') where entity_id = 9226;
UPDATE customer_entity SET created_at = CONVERT_TZ(created_at,'+10:00','+00:00'), updated_at = CONVERT_TZ(updated_at,'+10:00','+00:00');
UPDATE sales_flat_order_grid SET created_at = CONVERT_TZ(created_at,'+10:00','+00:00'), updated_at = CONVERT_TZ(updated_at,'+10:00','+00:00');
UPDATE sales_flat_invoice SET created_at = CONVERT_TZ(created_at,'+10:00','+00:00'), updated_at = CONVERT_TZ(updated_at,'+10:00','+00:00');
UPDATE sales_flat_invoice_grid SET created_at = CONVERT_TZ(created_at,'+10:00','+00:00'), order_created_at = CONVERT_TZ(order_created_at,'+10:00','+00:00');
UPDATE sales_flat_shipment SET created_at = CONVERT_TZ(created_at,'+10:00','+00:00'), updated_at = CONVERT_TZ(updated_at,'+10:00','+00:00');
UPDATE sales_flat_shipment_grid SET created_at = CONVERT_TZ(created_at,'+10:00','+00:00'), order_created_at = CONVERT_TZ(order_created_at,'+10:00','+00:00');