Inserting C# datetime milliseconds into sql Server DateTime

[tk042383]

On a C# datetime value I am using ToString(format) to specify a format of
"d/M/yyyy H:mm:ss:ffff" in trying to insert the value including its
milliseconds precision into a sqlServer 2000 DateTime column. I get error
241: "Syntax error converting to datetime from character string".

How do I insert the datetime value into a DateTime column so that it will
include the milliseconds component?

 

[Nicole Calinoiu]

Try using a maximum of three positions for the milliseconds.

HTH,
Nicole

 

[Tom Kirkman]

That was it. Thanks Nicole.

Tom