webmaster

UPDATE table_name 
    SET  updated_at = 
    CASE 
        WHEN old_datetime > 0 THEN CONVERT_TZ(FROM_UNIXTIME(old_datetime),'+00:00', '+08:00')  
    ELSE 
        NOW() 
    END