[dba-SQLServer] Date format

jwcolby jwcolby at colbyconsulting.com
Mon Jun 20 08:46:20 CDT 2011


 > Do not use Date type, use datetime type. Access does not handle the date type correctly.

Ooohhhh.

OK!

Thanks.

John W. Colby
www.ColbyConsulting.com

On 6/20/2011 9:28 AM, Robert Stewart wrote:
> Do not use Date type, use datetime type. Access does not handle the date type correctly.
>
>
> At 07:32 PM 6/18/2011, you wrote:
>> Date: Sat, 18 Jun 2011 20:24:21 -0400
>> From: jwcolby <jwcolby at colbyconsulting.com>
>> To: Sqlserver-Dba <dba-sqlserver at databaseadvisors.com>
>> Subject: [dba-SQLServer] Date format
>> Message-ID: <4DFD41B5.8010703 at colbyconsulting.com>
>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>
>> 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
>
> Robert L. Stewart
> www.WeBeDb.com
> www.DBGUIDesign.com
> www.RLStewartPhotography.com _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list