Hi Jun Kai,
For routine upper and lower digestive endoscopy, the recovery period is fast and estimated to be completed within 1 to 2 hours. One may experience some light headedness and unsteady gait for a short period of time, until the sedatives wear off.
Depending on what is done, there may be a sensation of gas in the abdomen and a mild throat discomfort, especially after a gastroscopy.
Most people can resume their normal diet after the procedure unless there are findings during endoscopy which requires a change. Just be prepared to spend half a day at the endoscopy centre, since the entire process involves preparations before the procedure and monitoring after the scopes.
Do arrange for someone to send you home after the procedure because one may still feel slightly sleepy for the rest of the day. Most doctors will be happy to issue you a medical certificate so that you can rest well at home after the procedure.