The Three and Ten at the bottom of Kemptown is always good for a late night on a school night (opens till 1am), but a quick google search and yelp suggests it is closed - can anyone confirm/deny?
The only other late night bar suggestion would be Rikki Ticks a Jamaican bar open until 2am but...