Remove timestamp in now()

I understand after running now() function in an SQL statement, I will get current date/time like following in mysql browser:

‘2010-08-04 17:01:06’

If I want the returned value to be ‘2010-08-04 00:00:00’. How can I do? Thanks.

Thanks for the prompt reply, R937. Will try it out.

use CURRENT_DATE instead of NOW()

vwalah :cool: