There's no such thing as empty date or time in SQL Server column. However if you specify only date portion for datetime field SQL Server will add 00:00:00 as a time when it converts it to datetime. EM doesn't show time portion of datetime if it's 00:00:00 assuming that only date part is relevant in this case.

>Hi!
>
>W2K Enterprize manager automatically recognizes datetime values that contain empty time protion and do nto display it. I have a couple of datetime fields in my database that hold only dates and never a time. They're also displayed only as a date fields. As opposite, I have a couple of date+time fields, that are displayed correctly by Enterprise Manager.
>
>>Hi all,
>>
>>I need to consult on the behaviour of the SQL Server Enteprise Manager. I have opened the pubs database and selected the employee table. Then I right-clicked and choose the return all rows. When the records are shown, why is the hire_date column does not show the time as well? This is a datetime type column and I thought the expected behaviour is to show date and time. Presently, I changed the SQL statement by clicking the "SQL" toolbar and use the convert function to show the time as well. Am I missing something?
>>
>>Regards