Inserting C# datetime milliseconds into sql Server DateTime

  • Thread starter Thread starter tk042383
  • Start date Start date
T

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

datacolumn datetime from UTC to Localtime 2
Inserting the datetime with milliseconds value into a datarow 6
Millisecond values missing when inserting datetime into datetime column of sql Server 4
Can't populate SQLServer datetime column with milliseconds 3
Conversion of .NET DateTime to SQL datetime via VarBinary 1
inserting DateTime in Sql Server 9
DateTime 14
How to insert c# DateTime? 3

Back
Top