Professional Web Applications Themes

date comparaison in SELECT IF(), not working - MySQL

Hello there, Can't one use date comparaison in a SELECT IF statement? Can't get it to work... this query works, it returns 3 rows: select EntryDate from Feedback where EntryDate > DATE_SUB(NOW(), INTERVAL 10 DAY) inside an IF, the same comparaison formula does not work - Answer is always NO select IF( EntryDate > DATE_SUB(NOW(), INTERVAL 10 DAY), 'YES', 'NO' ) as Answer from Feedback EntryDate type is 'datetime'. Using MySQL 4.0.25-standard so can't use DATE() or DATEDIFF()...

  1. #1

    Default date comparaison in SELECT IF(), not working

    Hello there,

    Can't one use date comparaison in a SELECT IF statement? Can't get it
    to work...

    this query works, it returns 3 rows:
    select EntryDate from Feedback where EntryDate > DATE_SUB(NOW(),
    INTERVAL 10 DAY)

    inside an IF, the same comparaison formula does not work - Answer is
    always NO
    select IF( EntryDate > DATE_SUB(NOW(), INTERVAL 10 DAY), 'YES',
    'NO' ) as Answer from Feedback


    EntryDate type is 'datetime'.

    Using MySQL 4.0.25-standard
    so can't use DATE() or DATEDIFF()

    zorro Guest

  2. #2

    Default Re: date comparaison in SELECT IF(), not working

    DOH!!!
    Of course it works, just wasn't seeing all rows - phpMyAdmin shows
    just 30 at a time !!


    boo hoo hoo, wasted 45 minutes


    zorro Guest

  3. #3

    Default Re: date comparaison in SELECT IF(), not working

    zorro wrote:
     


    By default, yes.

    Edit this row in the config file to change this behaviour:

    $cfg['MaxRows'] = 30; // maximum number of rows to display



    --
    Brian Wakem
    Email: http://homepage.ntlworld.com/b.wakem/myemail.png
    Brian Guest

Similar Threads

  1. SELECT ISNULL DATE
    By mikeap in forum Coldfusion Database Access
    Replies: 4
    Last Post: November 29th, 06:25 PM
  2. Replies: 0
    Last Post: September 24th, 03:24 AM
  3. Select TOP sql statement with date datatypes
    By J. Muenchbourg in forum ASP
    Replies: 5
    Last Post: September 12th, 01:44 PM
  4. Replies: 0
    Last Post: September 11th, 11:26 AM
  5. Replies: 0
    Last Post: September 11th, 12:19 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