[AccessD] Losing 3ms on date insert?

[Daniel Waters]

Is the Access file and the SQL Server on the same PC?  Or on a PC where SQL Server is on a Server?

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ryan W
Sent: November 21, 2018 10:47
To: Access Developers discussion and problem solving
Subject: [AccessD] Losing 3ms on date insert?

Has anyone seen an issue where:

INSERT INTO FOO SELECT * FROM BAR

Where FOO and BAR both contain a date column, but when inserted in from MS
Access to SQL the date loses 3ms?


The first two rows, proper date.. following rows -3ms ?

https://i.imgur.com/IYsKCbS.png (Screencap)
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com