'NOW' (cast to timestamp) will return both date and time,

'TODAY', 'TOMORROW', 'YESTERDAY' (cast to timestamp)
will return zero time portion.

Or you can cast 'NOW' to DATE only.

Or use CURRENT_DATE (recommended).

Ivan