Professional Web Applications Themes

Fitler by yesterday? - Microsoft SQL / MS SQL Server

WHERE datevalue >= DATEADD(DAY,-1,CONVERT(VARCHAR,CURRENT_TIMESTAMP,112)) AND datevalue < CONVERT(VARCHAR,CURRENT_TIMESTAMP,112) This includes the time of midnight yesterday (00:00:00.000) but not midnight today (midnight is always AM). -- David Portas ------------ Please reply only to the newsgroup --...

  1. #1

    Default Re: Fitler by yesterday?

    WHERE
    datevalue >= DATEADD(DAY,-1,CONVERT(VARCHAR,CURRENT_TIMESTAMP,112))
    AND datevalue < CONVERT(VARCHAR,CURRENT_TIMESTAMP,112)

    This includes the time of midnight yesterday (00:00:00.000) but not midnight
    today (midnight is always AM).

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --


    David Guest

  2. #2

    Default Re: Fitler by yesterday?

    Jason Davis wrote: 

    WHERE datecol >= convert(char(8),dateadd(day,-1,getdate()),112)
    AND datecol <convert(char(8),getdate(),112)

    HTH,
    Bob Barrows


    Bob Guest

  3. #3

    Default Re: Fitler by yesterday?

    Try the following:

    select *
    from yourtable
    where datecol >= cast(convert(varchar(10), getdate() - 1, 101) as datetime)
    and datecol < cast(convert(varchar(10), getdate(), 101) as datetime)

    -Sreehari

    "Jason Davis" <com> wrote in message news:<uXnDB#phx.gbl>... 
    Sree Guest

Similar Threads

  1. I got my new computer yesterday
    By benjamin@goukaku.com in forum Macromedia Flash
    Replies: 3
    Last Post: December 26th, 03:07 AM
  2. Why Cox went down day before yesterday?
    By jef@eyeintegrated.com in forum PHP Development
    Replies: 0
    Last Post: August 14th, 03:05 PM
  3. can not do what i did yesterday
    By David L Cochran in forum Adobe Photoshop Elements
    Replies: 1
    Last Post: August 11th, 11:34 PM
  4. get yesterday's date
    By Joel Gacosta in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 1st, 11:41 AM

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