Milliseconds, no milliseconds

[LCannon]

I have two SQL servers. One in version 7 and the other is a newly setup SQL 2000. In tables in each of them, I'm recording the date and time in a datetime field. In the version 7, I'm showing the date & time with the milliseconds. In the new SQL 2000, I'm showing the date & time but with ".000" for milliseconds.

What am I missing? I would like the milliseconds in the SQL 2000 servers but don't know how to get them. Pls help. Tks.

 

[jmerencilla]

use getdate().

select getdate()

---------
2002-08-13 16:12:10.487

the millisecond part is 487. this means that after 10 seconds, .478 of the next second has already elapsed.
it's a bit confusing because the millisecond part is already converted into the fractional part of a second.