The best time to pray in order to cancel the effects of a bad dream is immediately when you wake up out of that dream! Don't wait until later. If you prayed effectively, on going back to bed, God will likely show you another dream revealing that the effects of that bad dream have been canceled. Glory to God Almighty!