[AccessD] SQL datetime to Access date conversion

How about posting your Update Query?

On 31 Aug 2009 at 16:41, Doug Steele wrote:

> No, regular datetime.
> 
> On Mon, Aug 31, 2009 at 4:18 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:
> 
> > 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).
> >
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com