[dba-SQLServer] Date format

jwcolby jwcolby at colbyconsulting.com
Sat Jun 18 19:24:21 CDT 2011


I have a table where a field is a date type.  For some reason the date is stored (or at least 
displayed) in YYYY-MM-DD format.

In my Access FE I am trying to use the date picker from

http://allenbrowne.com/ser-51.html

All the other dates in the system work well with this control (form) but not this one specific date.

The format string placed in the access control does not modify it to be the more (American) normal 
mm/dd/yyyy.

Does anyone have any ideas why sql server would store / display it in this format?  If I reformat it 
on the way out to my form, can I store it back in in the more "normal" format and have it store?  	
-- 
John W. Colby
www.ColbyConsulting.com


More information about the dba-SQLServer mailing list