I think the devs are still working on the release of 23.2. We probably see it in october / november. Once it releases the availability depends solely on your distro. If you are on a fast updating / rolling distro such as tumbleweed or arch you’ll get the new packages very quickly (usually days / a week after release)

I normally use git so can’t say exactly how long, but there are typically 3 major releases per year, so you could estimate from that…