Hi all,

This is an extrapolated question from the actual QoD, but I would like to know the reason (coz of knowledge gaining reason)

Why the 'mmm' part in the RESULT section giving a different value than I entered through the character string as shown below.

SET DATEFORMAT MDY

DECLARE @dmy datetime

SELECT @dmy = '12/31/99 12:13:12:012'

SELECT @dmy

RESULT:

1999-12-31 12:13:12.013

Thanks

big[M]