All perfect praise be to Allaah, the Lord of the Worlds. I testify that there is none worthy of worship except Allaah, and that Muhammad, sallallaahu ‘alayhi wa sallam, is His Slave and Messenger.
If you drank water while being unsure of whether or not it was still daytime (i.e., the two possibilities, that the sun set or not, were of the same degree), then undoubtedly you would not be free from liability and you would be required to make up for that day because the basic premise is that it was still daytime and this premise would not have changed unless you were certain or most likely believed that it had ended.
If you drank water while thinking that the sun set and the day ended, you would not be required to make up for that day because the opposite was not proved to you.
Finally, we would like to state the following: It is impermissible for a Muslim to delay the obligatory prayer beyond its prescribed time without a valid excuse. Rather, every accountable (sane and pubescent) Muslim (man and woman) is obliged to perform the prayers on time. Missing prayers due to oversleeping is a valid excuse only if one exerted all means to wake up and perform them on time and nonetheless slept through them. However, one is sinful if he/she misses a prayer due to failing to utilize all available means to wake up and perform the prayer on time
And Allaah Knows best.