Date Display

I have a table in SQL Server 2000 with have date/time columns and
displays the dates as : 1900-01-01 00:00:00.000 which is fine, but when
I select the column through dreamweaver for an asp page to date is
shortened to 1900-01-01 but I need to see the whole date / time field
for conversion purposes.

Can anyone help ?

Thanks in advance.Dear Gecko,

You must know that MSSQL stores datetime values in an internal format,
and client decides how to display them. EM is also a SQL server Client
for server Management. as in your problem you go to following menu in
EM (Enterprize Manager) .

Tool->Options->Connections, check the third checkbox, "Use regional
settings...".

I think it may help you...

for date formate thing also visit see link for :
http://www.dbnest.com/contents.php?cid=63

Cheers.

Saghir Taj
(MCDBA)
DBNest: The Nest of DB Professionals.|||If its OK to use a string with the date formatted into it - look at the
convert function in SQL.

Otherwise dig into the DreamWeaver documentation for date value presentaion
(I can't help you there).

"Gecko" <simon.croome@.solent.ac.uk> wrote in message
news:1112872252.099657.75590@.z14g2000cwz.googlegro ups.com...
>I have a table in SQL Server 2000 with have date/time columns and
> displays the dates as : 1900-01-01 00:00:00.000 which is fine, but when
> I select the column through dreamweaver for an asp page to date is
> shortened to 1900-01-01 but I need to see the whole date / time field
> for conversion purposes.
> Can anyone help ?
> Thanks in advance.