Dear student,
At night, the effect of root pressure is more important in the transport of water. However, during the day, the stomata are open which generate transpiration pull by transpiration. The transpiration pull causes tension in xylem that results in transport of water present in the xylem. Therefore, the transpiration pull plays an important role in the transportation of water during the day.
Regards