To enter only time in a Date time field.

Last Post 06 Jun 2004 10:47 PM by MSNair79. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
MSNair79
New Member
New Member

--
06 Jun 2004 10:47 PM
Hi All,

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.

Manoj.
You are not authorized to post a reply.

Acceptable Use Policy