Is it possible to have a smalldatetime type hold just the time

[hoggle]

We need to store time (as military time) is there anyway to do this without storing it in a varchar?
Using either a datetime or smalldatetime type (but we don't want to store the date with it)

thanks!

 

[SQLBill]

No. DATETIME and SMALLDATETIME store both date and time. You can use the 'front-end' (asp, vb, crystal reports, etc) to retrieve only the time.

Insert only the time and SQL will add the default date, then do your query dropping/truncating the date off.

-SQLBill