|
|
Posted by --CELKO-- on 02/05/06 00:22
>> his will still bite you if smalldatetime is used. Or if ever an entrymakes it into the datebase with a 23:59:99.993 timestamp. <<
I never use SMALLDATETIME because it is soooo proprietary and does not
match the FIPS-127 requirements.
>> What is your objection to
SomeDate >= StartOfInterval
AND SomeDate < EndOfInterval <<
Mostly style and portable code. The BETWEEN predicate reads so much
better to a human. I would prefer OVERLAPS and some of Rick
Snodgrass's operators if i coudl get them.
>> FAICT, this will work on ALL products, regardless of the precision of the date and time datatypes used in the product. Am I wrong? <<
Yeah, yeah!! But I hate 5to split a single concept (between-ness) into
muliple predicates. I also hate a change of ORs when I can use IN(),
etc.
--
Navigation:
[Reply to this message]
|