Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  msde datetime

Author  Topic  coder Starting Member 16 Posts Posted - 2007-04-06 : 22:30:14 I have a question about the mssql datetime datatype. When I select the employee table from the sample pubs database, there is a datetime column called hire_date. (All I'm doing is Select * from employee;) Nothing else. When I bind this table to a datagrid, this datetime column shows only the date. (Which is fine.) But, when I delete a date and try to add a time to the column, it insists on showing both the date and the time. My question is, why is the column capable of showing only the date part of the dateime (without explicit code telling it to do so), but not capable of showing only the time? (I didn't do any coding that would affect what I see. I only did the the simple select statement and bound the table to a datagrid in C#.)