Professional Web Applications Themes

Mysql querry - MySQL

Hi I have a problem with mysql querry SELECT * FROM viewfor_prop_for_search WHERE createdon BETWEEN NOW() AND NOW() + INTERVAL 20 day; i try get rows added in last 20 days. creadon is datetime type Why it doesn't work Sebastian...

  1. #1

    Default Mysql querry

    Hi

    I have a problem with mysql querry

    SELECT * FROM viewfor_prop_for_search WHERE createdon BETWEEN NOW()
    AND NOW() +
    INTERVAL 20 day;

    i try get rows added in last 20 days.

    creadon is datetime type

    Why it doesn't work


    Sebastian

    Sebastian Guest

  2. #2

    Default Re: Mysql querry

    Sebastian wrote: 

    Because now plus 20 days is 20 days from now!

    E.g. now is Friday. Now plus 2 days is Sunday.

    Get the idea?


    Paul Guest

  3. #3

    Default Re: Mysql querry

     

    Hehe, i make mestake, but with minus is doesn't work to

    Sebastian Guest

  4. #4

    Default Re: Mysql querry

    == Quote from Sebastian (com)'s article 
    > Hehe, i make mestake, but with minus is doesn't work to[/ref]

    i just tried this on a timestamp field and it didn't work either.
    --
    POST BY: lark with PHP News Reader
    lark Guest

  5. #5

    Default Re: Mysql querry

    Sebastian wrote: 
    >
    > Hehe, i make mestake, but with minus is doesn't work to[/ref]

    Well I don't know why lark couldn't get it to work but I just tried:

    SELECT * FROM `viewfor_prop_for_search` WHERE `createdon` BETWEEN NOW() -
    INTERVAL 20 DAY AND NOW();

    and it worked fine.

    Could you post an extract from your table (the create statement and some
    inserts) and your query so I can see what's wrong.


    Paul Guest

Similar Threads

  1. Multiple insertion querry
    By Eric Kincl in forum PHP Development
    Replies: 2
    Last Post: November 19th, 10:30 PM
  2. Improve this querry!?
    By Mark in forum Oracle Server
    Replies: 5
    Last Post: November 10th, 09:39 PM
  3. MySQL querry
    By Eric Kincl in forum PHP Development
    Replies: 4
    Last Post: October 8th, 10:29 PM
  4. SQL querry vs Access qry
    By Ray in forum Microsoft SQL / MS SQL Server
    Replies: 8
    Last Post: July 18th, 02:18 PM
  5. Querry by date
    By Douglas J. Steele in forum Microsoft Access
    Replies: 2
    Last Post: July 5th, 01:30 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