Save date with milliseconds using oleDB

[Marcio_cota]

I´m using SqlServer

With ODBC I save current datetime and milliseconds is save in database
With OleDB the milliseconds isn´t save into database

How can I save milliseconds into sqlserver datetime column with oledb??

[EWetzel]

Hi,

I had the same problem.

I convert the datetime-var in a string-var for the sqlserver with the format "yyyy-mm-dd hh:mm:ss.nnnnnnn" and
save this string-var in a datetime2 column.
In my case this works.

best regards
Enrico

[Jeff Luther]

Thanks for the tip, Enrico!

[Marcio_cota]

is there no other way to do this?

Getdate() has 3 number into milleseconds but if I save this string date it just save 2 number

Ex:
Getdate() = 2010-04-09 09:01:39.376
Saved ==== 2010-04-09 09:01:39.38