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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement