[AccessD] SQL datetime to Access date conversion

Are you using datetime or smalldatetime as your datatype in SQL Server.

smalldatetime is only accurate to one minute (time is stored as two bytes representing the 
number of minutes past midnight).  

-- 
Stuart
 

On 31 Aug 2009 at 15:27, Doug Steele wrote:

> Hello All:
> 
> I have a SQL 2005 table linked into an Access db.  I am using an update
> query in Access to move some datetime fields from SQL Server to an Access
> table.  It almost works - the dates are OK, but I am getting times which are
> sometimes out by a couple of minutes: for instance the time part of one
> field, 2:00:00 PM in SS, is changed to 1:58:07 PM in Access.
> 
> Does anyone have any suggestions about why this happens?
> 
> Thanks,
> Doug Steele
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com