不行,应该用介词in
The water was frozen in such cold weather.
天气并非动作执行者,至于说是系表结构或被动语态,我认为都行.
又如：
South China grows rice.
-----Rice is grown in South China.