pineapples are tropical plants, so i would imagine that a freeze would likely do some harm. not sure exactly how long it will take to get fruit. a few months at least
In my climate, it is unlikely we will ever get to the fruiting stage, but it is pretty fun to see a vibrant pineapple plant growing up out of the old top of a store-bought pineapple. Great project for kids (including the 30+ yr old type).