View Full Version : Sql query to return date that are not in the format of 1900-00-00

10-07-2011, 11:45 AM
so far i have this query..

SELECT `dateOfBirth`
FROM `friend_req`
WHERE `dateOfBirth` != '0000-00-00'
AND `dateOfBirth` != '1900'
LIMIT 0 , 30

how do i write this query in such a way that it doesnt pick up dates like 1900-01-04 or 1900-10-01 or 1900-08-28

10-07-2011, 01:00 PM
how about:

Old Pedant
10-07-2011, 07:16 PM
Ummm...Bubikol, the problem is that he foolishly did *NOT* store dateOfBirth as a SQL DATETIME field. Apparently he stored it as VARCHAR. So now he is hosed. He has to use ONLY string manipulation to get his answer.

Kevin: Any chance you can change your field from VARCHAR to DATETIME, so that you *can* use all the very very useful MySQL DATE and TIME functions? Which you can't do, now.