Dates

Show current date YYYY-MM-DD

SELECT current\_date; 

Calculate age between two dates

SELECT age(timestamp, timestamp); 

Show current time with time zone

SELECT current\_time; 

Make dates using integers

SELECT make_date(2021,03,25);