If I am opening an account in the middle of a month, do I need to pay for the full month charges?

When you join an unlimited trading plan in any day of the month, you need to pay full fees of the plan. After that 1 paisa brokerage (which is negligible) amount. There is no prorated brokerage concept in unlimited trading plans.