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);
Comments