A pyramid with a square base of side 6 cm and height 9 cm is filled with water. If this water is poured into a cone with a radius of 3 cm, what is the height of the water in the cone?