I am using a table in which there is a datetime field in which, I want to enter only time. I have tried out the Convert and Cast functions available in SQL Server, but it still displays the date with time i.e. 01/01/1900 10:00:00 in the enterprise manager. Where as I wanted only time to be displayed.
Can anybody help me with a solution. I cannot use trigger / procedures since the table is present in the client side & and I have to enter the time into the clients database.