Get current date and time in PostgreSQL

now()

- or -

CURRENT_DATE + CURRENT_TIME

Know more: