How to drill on datetime data without aggregating into level above

I have some data with a DateTime column. What I need to be able to do is drill down to the second level. I've created my own hierarchy Year>month>day>hours>minutes>seconds.   The only problem is if...