469,625 Members | 1,066 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

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.

Jul 23 '05 #1
2 1074
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.

Jul 23 '05 #2
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" <si**********@solent.ac.uk> wrote in message
news:11*********************@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.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Marauderz | last post: by
12 posts views Thread by DC Gringo | last post: by
6 posts views Thread by yoshitha | last post: by
2 posts views Thread by Lars Erik Nes | last post: by
3 posts views Thread by Bob Sanderson | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.