Professional Web Applications Themes

MySQL compare dates - MySQL

Hello, I'm trying to select all records where the value stored in the 'Time_Out' field, which dtores datetimes, is a date in front of that specified (in this case 2007-4-18 00:00:00) I'm getting very stuck... can someone help? Cheers, Ben SELECT * FROM board WHERE `Time_Out` > 2007-04-18 00:00:00 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00' at line 1...

  1. #1

    Default MySQL compare dates

    Hello,

    I'm trying to select all records where the value stored in the
    'Time_Out' field, which dtores datetimes, is a date in front of that
    specified (in this case 2007-4-18 00:00:00)

    I'm getting very stuck... can someone help?

    Cheers,

    Ben

    SELECT * FROM board WHERE `Time_Out` > 2007-04-18 00:00:00

    You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use
    near '00:00:00' at line 1

    Ben Guest

  2. #2

    Default Re: MySQL compare dates


    "Ben" <com> wrote in message
    news:googlegroups.com... 

    Shouldn't that be encapulated in quotes?

    SELECT * FROM board WHERE `Time_Out` > '2007-04-18 00:00:00'




    Sean Guest

  3. #3

    Default Re: MySQL compare dates

    On Apr 18, 3:11 pm, Ben <com> wrote: 

    Try
    SELECT * FROM board WHERE `Time_Out` > '2007-04-18 00:00:00'


    Captain Guest

  4. #4

    Default Re: MySQL compare dates

    On Apr 18, 3:11 pm, Ben <com> wrote: 

    Take a couple of these. You'll feel better

    ' '

    strawberry Guest

  5. #5

    Default Re: MySQL compare dates

    On Apr 18, 4:31 pm, strawberry <com> wrote: 






    >
    > Take a couple of these. You'll feel better
    >
    > ' '- Hide quoted text -
    >
    > - Show quoted text -[/ref]

    Love it!

    Captain Guest

Similar Threads

  1. How to you compare dates in a query in Mysql
    By Safal Solutions in forum PHP Development
    Replies: 2
    Last Post: December 23rd, 02:12 PM
  2. Compare dates for conflict
    By John Gillett in forum Macromedia ColdFusion
    Replies: 1
    Last Post: February 24th, 06:21 PM
  3. Compare dates
    By Shaun in forum PHP Development
    Replies: 2
    Last Post: September 29th, 12:24 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