[Resolved] [Resolved] MySQL question - compare Date and Timestamp

[freebie]

Hi,
I have a MySQL Timestamp column that I need to do a date comparison on (The date is coming from form fields). here's the part of the WHERE clause that I'm trying to do the comparison, but MySQL doesn't like what I'm trying to do. This is after processing of the PHP to clarify.

... AND STR_TO_DATE(FROM_UNIXTIME(born),'%Y-%m-%d') >= '2003-01-01' .....

"born" is the Timestamp column in the MySQL database. When I paste the SQL statement into PhpMyAdmin, it says that there's an error in the SQL syntax and it shows this part of the query as the problem.

Can someone clue me in as to what I should be doing?
Thank you for any ideas.

Jeff

[freebie]

I figured this one out. I should have tried the simplest thing first which is to just do a direct comparison without any functions. That's what worked