How to store and display ONLY time value of datetime field
Posted on 2010-11-30
I can connect to sql server from Microsoft Access. If I put a time value in a datetime field, it displays in the table correctly. eg. 4:00:00 PM
If I try to input a record using sql stored procedures, it always stores and displays the date 1/1/1900 in front of the time even though I send the time to the table like this: CONVERT(char(10), Login, 8). How can I write a stored procedure that will store and display ONLY the Time value. It's obvious that the table can store it that way because it works when sending it from Access.