Thanks.. you can tell im a beginner

Well Im sorry to have wasted your time, I had accidently made it a varchar not a datetime,...

What version of SQL server are you using? I think I'm using 2003. I created the same table as in your example and for some reason still get the 12:49...

SELECT MAX(to_time) as max1 FROM rolling_average

table name: rolling_average

DateTime field: to_time