Need data type for date and time in sqlserver

[dhilipkumar]

Need data type for date and time in sqlserver

i need to store time values in sqlserver (field type set as DateTime) but it stores data with a default date along with time entered by user at form level .

how can i display only time value on the form because sqlserver doesnot provide any format settings for that field and also i am unable to find any such method in dot net that can transform that value only in time when displaying on forms.... im using VB.NET