Storing Just time in datetime

[Guest_imported]

Im currently writing a ASP script which has to store a time in a datetime function(hh/mm/ssAM), unfortunately everytime I try to insert anything it looks like this: 1/1/1900 2:03:00 AM, can anyone tell me how to get rid of the date and just display the time?

 

[redlam]

I'm pretty sure you can't 'store' a time without a date in a SQL table... but if you are aiming to display only the time, you can use the convert function using the style parameter to format your results.<br><br>declare @datefield smalldatetime<br>set @datefield = '1/1/1900 2:03:00 AM'<br><br>select convert(varchar, @datefield, 8)<br><br>