Compare user entered date with database date time

[ghjk]

I want to compare user entered date with data base datetime value. Database value in datetime type and first i want to extract date part and then compare with user entered value. This is my query. Could someone tell me what is wrong with it?

[PHP]SELECT * FROM db WHERE Date = SELECT CAST(Date AS DATE) AS dateonly FROM db[/PHP]

[Markus]

I want to compare user entered date with data base datetime value. Database value in datetime type and first i want to extract date part and then compare with user entered value. This is my query. Could someone tell me what is wrong with it?

[PHP]SELECT * FROM db WHERE Date = SELECT CAST(Date AS DATE) AS dateonly FROM db[/PHP]

I'd recommened asking in the mysql forum!

[ronverdonk]

This is not a PHP question, but a MySql one. I will move this thread to the MySQL forum.

moderator

[ronverdonk]

You are triple posting! You opened a MySQL thread in the PHP and in two in the MySQL forum. And this question has nothing to do with PHP.

warning: do not double/triple post, especially not in a non-question releated forum. Not complying on this with the Posting Guidelines on this will result in a ban from this site next time.

moderator

[ronverdonk]

What is the user-entered value in this query?[code=sql]SELECT * FROM db WHERE Date = SELECT CAST(Date AS DATE) AS dateonly FROM db[/code]Ronald