If you cancel the Playonline Account (or the Square-Enix account), I believe it's immediate. However, if you instead cancel the "Option" (formerly "Content ID") for your the character, you will be able to login until the end of the current subscription period.

There is a definite difference between canceling a single character option, and canceling the entire account. However, either of these cancellations will stop all future billing.