Below is a full list of date/time functions available in PostgreSQL.

• age()
• clock_timestamp()
• current_date
• current_time
• current_timestamp
• date_part()
• date_trunc()
• extract()
• isfinite()
• justify_days()
• justify_hours()
• justify_interval()
• localtime
• localtimestamp
• make_date()
• make_interval()
• make_time()
• make_timestamp()
• make_timestamptz()
• now()
• statement_timestamp()
• timeofday()
• timezone()
• to_date()
• to_timestamp()
• transaction_timestamp()