Writing a tenant lease for 6 months in Oakland, CA

[Jalaj Punn]

Hello! I want to write a 6 month lease to a tenant for my SFH in Oakland, CA. If I explicitly stated in the lease that it's a 6 month lease, will the tenant be required to move out after the lease ends?

I’m not sure if this is true or not, but from what I’ve heard the tenant falls in a month-to-month lease after the lease ends? If that is true, how would I be able enforce they leave after the 6 months? Mainly asking because I want to move in to the house after 6 months.