The longest I've sat was about 8 hours. I've also done a 7 hour session where I could have gone longer, but my budget ran out!
The longest I've tattooed is a killer 12 hour session, followed by a quick nap before I opened up the shop again. I was younger back then... Not that I had more stamina, I just tattooed a lot slower!