[AccessD] bit OT VB6 Application Problem With Moving to SQL Server 2019

[Paul Hartland]

To all,

We have a VB6 application that has been running on SQL server 2012/2014 for
a few years now, we have recently started to move to SQL server 2019 have
have encountered a date error.  The general error being is something like
Datatype Mismatch

If I profile the SQL Server date being updated looks like the one below
with nine digits for the milliseconds.
[image: image.png]

If I profile it on SQL Server 2012/2014 I get no error and datetime is the
same as above but without the .215696444 and all is fine, any ideas what
this could be.


-- 
Paul Hartland
paul.hartland at googlemail.com