Add a timezone-specific variant of date_trunc(). date_trunc(field, timestamptz, zone_name) performs truncation using the named time zone as reference, rather than working in the session time zone as is the default behavior. It's equivalent to
date_trunc(field, timestamptz at time zone zone_name) at time zone zone_name but it's faster, easier to type, and arguably easier to understand. Vik Fearing and Tom Lane Discussion: https://postgr.es/m/[email protected] Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/600b04d6b5ef6c9ad3ea684aad40260bd60d5872 Modified Files -------------- doc/src/sgml/func.sgml | 53 ++++++++++++++--- src/backend/utils/adt/timestamp.c | 97 +++++++++++++++++++++++++++---- src/include/catalog/catversion.h | 2 +- src/include/catalog/pg_proc.dat | 19 +++--- src/test/regress/expected/timestamptz.out | 18 ++++++ src/test/regress/sql/timestamptz.sql | 4 ++ 6 files changed, 166 insertions(+), 27 deletions(-)
