Function Category: Date/Time Functions

85 articles

age() — PostgreSQL date/time function

age(): age of a transaction ID, in transactions before current transaction. PostgreSQL date/time functions — signature, volatility, version applicability and…

date() — PostgreSQL date/time function

date(): convert timestamp with time zone to date. PostgreSQL date/time functions — signature, volatility, version applicability and an illustrative example.

date_add() — PostgreSQL date/time function

date_add(): add interval to timestamp with time zone. PostgreSQL date/time functions — signature, volatility, version applicability and an illustrative example.

date_bin() — PostgreSQL date/time function

date_bin(): bin timestamp into specified interval. PostgreSQL date/time functions — signature, volatility, version applicability and an illustrative example.

date_part() — PostgreSQL date/time function

date_part(): extract field from timestamp with time zone. PostgreSQL date/time functions — signature, volatility, version applicability and an illustrative example.