Function Category: Date/Time Functions

85 articles

date_subtract() — PostgreSQL date/time function

date_subtract(): subtract interval from timestamp with time zone. PostgreSQL date/time functions — signature, volatility, version applicability and an illustrative example.

date_trunc() — PostgreSQL date/time function

date_trunc(): truncate timestamp with time zone to specified units. PostgreSQL date/time functions — signature, volatility, version applicability and an illustrative…

extract() — PostgreSQL date/time function

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