Do you have a use-case you'd like to share or is this curiosity after accidentally finding out that 'now'::timestamp actually works?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных