diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2018-11-14 15:41:07 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2018-11-14 15:41:07 -0500 |
| commit | 600b04d6b5ef6c9ad3ea684aad40260bd60d5872 (patch) | |
| tree | 042a86af0ea3063ea3aaa75958e4d73e57819381 /src/backend/executor/nodeWorktablescan.c | |
| parent | 06c723447b6b8fc7e394cd2ad23785a6e54e36da (diff) | |
| download | postgresql-600b04d6b5ef6c9ad3ea684aad40260bd60d5872.tar.gz postgresql-600b04d6b5ef6c9ad3ea684aad40260bd60d5872.zip | |
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/6249ffc4-2b22-4c1b-4e7d-7af84fedd7c6@2ndquadrant.com
Diffstat (limited to 'src/backend/executor/nodeWorktablescan.c')
0 files changed, 0 insertions, 0 deletions