Get current date in PostgreSQL

now()::DATE

DATE(now())

CURRENT_DATE