Postgres sql function - ghdrako/doc_snipets GitHub Wiki

• now() function will return the transaction time

SELECT now(), now();

• clock_timestamp() function return the real time

SELECT clock_timestamp(), clock_timestamp();

• format - function simulate printf

select format('%s %s', forename, surname) as fullname
  from users;