Professional Web Applications Themes

Selecting Date - Microsoft SQL / MS SQL Server

hi, In my database my date field having date and time info. But for selecting records i am passing only date value (No time). I am using following comparision cast(convert(varchar,DateField,101) as datetime) >= cast (Convert(varchar,''' + FromDate + ''' ,101) as datetime) Any other best way is there? I am using cast and convert function in both place. I want to write it in a better way. Please let me know. thanks, Ramesh...

  1. #1

    Default Selecting Date

    hi,
    In my database my date field having date and time info.
    But for selecting records i am passing only date value (No
    time). I am using following comparision

    cast(convert(varchar,DateField,101) as datetime) >= cast
    (Convert(varchar,''' + FromDate + ''' ,101) as datetime)

    Any other best way is there? I am using cast and convert
    function in both place. I want to write it in a better way.
    Please let me know.

    thanks,
    Ramesh
    Ramesh Guest

  2. #2

    Default Re: Selecting Date

    When comparing date values without time the best way to compare is

    select convert(varchar(8), DATEFIELD, 112) - This willl produce the output
    as YYYYMMDD

    Better use this format for making comparisons.

    Thanks,
    Jagan Mohan
    Software Engineer
    MCP

    "Ramesh" <jr_babuhotmail.com> wrote in message
    news:024501c342f2$dfaf91d0$a001280aphx.gbl...
    > hi,
    > In my database my date field having date and time info.
    > But for selecting records i am passing only date value (No
    > time). I am using following comparision
    >
    > cast(convert(varchar,DateField,101) as datetime) >= cast
    > (Convert(varchar,''' + FromDate + ''' ,101) as datetime)
    >
    > Any other best way is there? I am using cast and convert
    > function in both place. I want to write it in a better way.
    > Please let me know.
    >
    > thanks,
    > Ramesh

    Jagan Mohan Guest

  3. #3

    Default Re: Selecting Date

    Why do you need to cast and convert? Can you show sample data, and which
    row(s) should match a sample query? Usually you can just do this:

    WHERE DateField >= FromDate

    This will capture any row where DateField is greater than or equal to
    FromDate at midnight.

    --
    Aaron Bertrand, SQL Server MVP
    [url]http://www.aspfaq.com/[/url]

    Please reply in the newsgroups, but if you absolutely
    must reply via e-mail, please take out the TRASH.


    "Ramesh" <jr_babuhotmail.com> wrote in message
    news:024501c342f2$dfaf91d0$a001280aphx.gbl...
    > hi,
    > In my database my date field having date and time info.
    > But for selecting records i am passing only date value (No
    > time). I am using following comparision
    >
    > cast(convert(varchar,DateField,101) as datetime) >= cast
    > (Convert(varchar,''' + FromDate + ''' ,101) as datetime)
    >
    > Any other best way is there? I am using cast and convert
    > function in both place. I want to write it in a better way.
    > Please let me know.
    >
    > thanks,
    > Ramesh

    Aaron Bertrand [MVP] Guest

Similar Threads

  1. JSObject returns wrong date. How can Iextract correct date from digital signature?
    By Hal_Underwood@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 0
    Last Post: February 19th, 01:22 AM
  2. Replies: 1
    Last Post: October 24th, 11:38 AM
  3. selecting by date
    By Peter in forum MySQL
    Replies: 4
    Last Post: November 29th, 08:32 AM
  4. Automatically selecting date range
    By chipjohns in forum Coldfusion Database Access
    Replies: 8
    Last Post: October 19th, 06:06 PM
  5. selecting based on a month in a date
    By Creative Solutions New Media in forum PHP Development
    Replies: 0
    Last Post: August 28th, 10:19 PM

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