Postgres sql function
ghdrako edited this page Feb 20, 2024
·
1 revision
-
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;
Test