If you are determined to store only time, then one other way is to store the value in a non-datetime column, i.e. a varchar or an int. Depending on what subsequent calculations you might try to perform, this might work okay. But SQL Server will always store the date in a datetime column; if you don;t specify one, it will assign a default of 1900-01-01. But then it sometimes is just a simple matter of formatting, as others have mentioned above.