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