I have a database that has several datetime columns. The thing is all I care about is the time portion of the column. The thing is I need to retain the numeric time value as I will need to do time difference calculations on the remaining time values. I know I cannot store this data in SQL as a datetime but I want to be able to display the time without on my reports without showing the bogus date used by SQL when you only load the time value in a datetime column. Any guidance would be appreciated.