[AccessD] Losing 3ms on date insert?

[Daniel Waters]

That is a puzzle - I have no answer.  :-(

Dan

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

No SQL Server is on a VM... but these are 'set' dates, not using GETDATE()
or DATE() or a function where a tiny time discrepancy like that might show
up.

So the source table has 11/20/2018 16:00 as the date, but the destination
table, after the first two rows gets rolled back by 3ms for some reason.



On Wed, Nov 21, 2018 at 10:54 AM Daniel Waters <df.waters at outlook.com>
wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com