Date datatype does not display time when selected

Default date format is set to DD-MON-YY. This can be changed by running below sql.

alter session set nls_date_format = 'dd/mm/yyyy hh24:mi:ss';

SQL Server 2005 Express and 2008 Express Side by Side

Normally this fails due to - The SQL Server 2005 Express Tools are installed i.e. SQL Server 2005 Management Studio....There are two ways of fixing it...

a) Remove 2005 Management Studio...and then try to Install SQL Server 2008 Express Edition..I have not tried this as I wanted both Management Studion i.e 2005 and 2008...Needless to say 2008 Management Studio can access SQL Server 2005 Database.

b) While installing SQL Server 2008 Express it checks for Registry Key HKLM/SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM....rename this key from ShellSEM to ShellSEM.old. Install SQL Server 2008 Express...after installation name it back to ShellSEM...now both Management Studio will be in working state...