If I recall correctly its midnight pacific time the day after the player goes to waivers.
However, you dont have to stay up, just do the trade. then if no one else goes for him, you win. If someone else is watching him, and I suspect they will be and they have a hiogher waiver priority....well you know what that means
I dont think anyone else can see your waiting waiver request, so your good to go.