Three to six hours are pretty standard when doing weekly DnD, but DnD parties (like LAN parties) are also pretty awesome every now and again.

But I cannot really imagine purely doing 12 hour games. Weekdays are too short for that, and I prefer keeping weekends free for non-repeating events.