[dba-SQLServer] 'Just Date' criteria.

John Maxwell @ London City John.Maxwell2 at ntl.com
Wed May 18 13:55:07 CDT 2005


Hello all,

apologies if basic question but your help is appreciated.

Issue / Problem:
I need to select data with a particular date value 
but ignore the time contained in the data.
ie all records from a particular day what ever the time

I can see a number of solutions eg.
*	Convert date (Guess not always good solution as may not use
available indexes)
*	Use range in criteria (Is this efficient)
*	Use multiple date part functions (Is this efficient  and any
different from point above)

Any views / advice on what is usually the most efficient method would be
great

Thanks in advance

john


The contents of this email and any attachments are sent for the personal attention
of the addressee(s) only and may be confidential.  If you are not the intended
addressee, any use, disclosure or copying of this email and any attachments is
unauthorised - please notify the sender by return and delete the message.  Any
representations or commitments expressed in this email are subject to contract. 
 
ntl Group Limited




More information about the dba-SQLServer mailing list