It would depend on the dosage and the type of plant.

[flip flip flip] Aconite would be within an hour or even near instantaneous with a large enough dosage. Hemlock would take several hours. Nightshade takes quite a bit longer and may possibly even last over a day, although the symptoms would be obvious.