Re: Primary Key with a datetime datatype

From: Colleen Rossman (crossman_at_discussions.microsoft.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 14:09:07 -0700

Yes, the vendor does claim it's 'by design' and it's been this way for a long
time. However I found a 'set dateformat=dmy' statement in the trace output
which works in QA, allowing me to pass ddmmyyyy format without error, but it
didn't work in the app and that's teh real issue here.

Colleen

"Adam Machanic" wrote:

>
> "Colleen Rossman" <crossman@discussions.microsoft.com> wrote in message
> news:DDBAF283-CC40-408A-B942-428DF8A157E3@microsoft.com...
> >
> > SQL profiler indicated the app was passing a date value in format that is
> > incompatible (passing dd-mm-yyyy). I am able to reproduce the error in
> Query
> > Analyzer.
> >
> > Is there something I don't know about the internal storage of a primary
> > key/datetime datatype that would cause this error?
>
> Aboslutely not...
>
> But why did the date format that the app is passing change? Does the
> vendor claim that it was that way before?
>
>
>