[AccessD] text control Date formats with SQL Server

Stuart McLachlan stuart at lexacorp.com.pg
Fri Feb 17 16:59:54 CST 2012


Because ISO format is the default format for a date in SQL (Server) and it is  doing an 
implicit conversion form Date to Varchar using that default?

--
 

On 17 Feb 2012 at 14:17, jwcolby wrote:

>I am also not 
> sure why SQL Server stores the date (it is a date coming back from a date picker) in YYYY-MM-DD 
> format into the varchar() field.
> 
> John W. Colby
> Colby Consulting
> 



More information about the AccessD mailing list