Groups > comp.databases.ms-sqlserver > #1594

Re: SSE Weird Day of the Week Result

From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: SSE Weird Day of the Week Result
Date	2011-02-08 12:36 -0800
Organization	A noiseless patient Spider
Message-ID	<v8a3l6peh9miui79p07vfob3c6eltc6qmp@4ax.com> (permalink)
References	<n131l6pi5hjar02s6vglmr5phm43qqvvv8@4ax.com> <4d50e84e$0$41114$e4fe514c@news.xs4all.nl>

Cross-posted to 2 groups.

Show all headers | View raw

On Tue, 08 Feb 2011 07:52:59 +0100, Jeroen Mostert
<jmostert@xs4all.nl> wrote:

>On 2011-02-08 01:26, Gene Wirchenko wrote:
>>       I am continuing with the textbook I have been studying off and
>> on.  I found an interesting error in the date/time functions.
>
>I hope you mean an error in how the textbook uses them, not the functions 
>themselves. Standard functions/libraries rarely contain gross errors because 
>they would have been found and fixed by now.

     Ouch.  Yes, I meant the textbook.

[snip]

>The implicit conversion between INT and DATETIME is a misfeature that can 
>easily trip you up, but there's no error in the functions.

     I thought it might be that.  Misfeature is right.

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Re: SSE Weird Day of the Week Result Jeroen Mostert <jmostert@xs4all.nl> - 2011-02-08 07:52 +0100
  Re: SSE Weird Day of the Week Result Gene Wirchenko <genew@ocis.net> - 2011-02-08 12:36 -0800

csiph-web