In August, the weather in Columbia is typically hot. Average daily high temperature in August is about 28 degrees above zero. On average, Columbia has 20 sunny, 8 partly cloudy, and 3 rainy days in August. The rains are usually light. August as well as September is considered the most comfortable time to visit Columbia.