Professional Web Applications Themes

Which is Better - Microsoft SQL / MS SQL Server

Hi, I have to retrieve the record between 2 dates. Is it better, if we give date between 'somedate' and 'otherdate' OR date >= 'somedate' and date <= 'otherdate' Which is faster? Susanth....

  1. #1

    Default Which is Better

    Hi,
    I have to retrieve the record between 2 dates. Is it better, if we give
    date between 'somedate' and 'otherdate'
    OR
    date >= 'somedate' and date <= 'otherdate'

    Which is faster?

    Susanth.


    Susanth Sivaram Guest

  2. #2

    Default Re: Which is Better

    Internally it is essentially the same. Do what makes sense for your
    situation and or preference. Some people find BETWEEN easier to read and
    some do not.


    --

    Andrew J. Kelly
    SQL Server MVP


    "Susanth Sivaram" <susanthshotmail.com> wrote in message
    news:ORXAW4sRDHA.1552TK2MSFTNGP10.phx.gbl...
    > Hi,
    > I have to retrieve the record between 2 dates. Is it better, if we
    give
    > date between 'somedate' and 'otherdate'
    > OR
    > date >= 'somedate' and date <= 'otherdate'
    >
    > Which is faster?
    >
    > Susanth.
    >
    >

    Andrew J. Kelly Guest

  3. #3

    Default Re: Which is Better

    Performance-wise, they are the same (BETWEEN is internally converted to >= AND <=). However,
    make sure you get the same logic. Say you want one particular date:

    date BETWEEN '20030601' AND '20030602'
    Above will also return rows for 2003-06-02 00:00:00

    date BETWEEN '20030601' AND '20030601 23:59:59.999'
    Above will also return rows for 2003-06-02 00:00:00, because precision of datetime datatype and
    rounding.

    date >= '20030601' AND date < '20030602'
    Above will give desired result.

    --
    Tibor Karaszi, SQL Server MVP
    Archive at: [url]http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver[/url]


    "Susanth Sivaram" <susanthshotmail.com> wrote in message
    news:ORXAW4sRDHA.1552TK2MSFTNGP10.phx.gbl...
    > Hi,
    > I have to retrieve the record between 2 dates. Is it better, if we give
    > date between 'somedate' and 'otherdate'
    > OR
    > date >= 'somedate' and date <= 'otherdate'
    >
    > Which is faster?
    >
    > Susanth.
    >
    >

    Tibor Karaszi Guest

  4. #4

    Default Re: Which is Better

    Also don't use string values as the implicit conversion may more often do a
    string comparison instead of a date comparision. DOing an explicit cast will
    ensure that doesn't happen. This is for either situation.


    "Tibor Karaszi" <se>
    wrote in message news:phx.gbl... 
    AND <=). However, 
    datetime datatype and 
    http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver [/ref]
    give 
    >
    >[/ref]


    James Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139