For some reason I don't seem to get notifications for all of the topics here, sorry I just noticed this question now. A tile which is under water will become Sand after 3 in game days.