Function Category: Date/Time Functions

85 articles

timetz() — PostgreSQL date/time function

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

timezone() — PostgreSQL date/time function

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

to_char() — PostgreSQL date/time function

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