I guess I had suspicions that he wasn't real when I was about 5 or 6 but I kept fooling myself because it was more fun until I was about 8 or so.
Since I have older brothers, the fun kind of got ruined for me early on because they spoiled it by trying to get me to snoop for their presents.