Results 1 to 12 of 12
Jan 16, 2005, 06:09 #1
- Join Date
- May 2004
- Sunshine Coast, Australia
- 0 Post(s)
- 0 Thread(s)
SELECT query, '>' on a DATETIME field...
I have a few loops in my PHP program and in the last one i have a mysql_query which checks 2 DATETIME fields, the date im checkin it against doesnt even seem to matter. Even if i typed something like "...WHERE date1 = 'abc';" it still returns the query as TRUE.
Is mySQL supposed to ignore it if the queryed data is incorrectly formatted ?
And if it is correct can you query a DATETIME field with dates that are '>' larger than so on ?