In NYC, you bring in passport, picture and application in the morning. Usually 3-5 days but for a few extra dollars you can pick up next day.

Btw, looks like 2 yr tourist visa no longer available. My 2 yr expired and they would give me a one yr - and I am ABC.