Soda water contains gas. The longer you leave it open, the more the gas will be released. At one point, the gas will be totally released and the water will just be normal drinking water. To fully enjoy the fizzy effect of the soda water, it is best opened (it often comes in bottles or cans) and mixed right before serving.