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