From: Nandish Bhuva <Nandish.bhuva@srmsoftwareinc.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Timezone handling with timestamp without time zone columns
Thread-Topic: Timezone handling with timestamp without time zone columns
Thread-Index: AQHcpjB1s/2fqObN5061HSQqqhbODg==
Date: Wed, 25 Feb 2026 08:28:28 +0000
Message-ID:
 <YT4P288MB01507D63F23F6B505AEB759E8375A@YT4P288MB0150.CANP288.PROD.OUTLOOK.COM>
Accept-Language: en-US
Content-Language: en-US
msip_labels:
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=srmsoftwareinc.com;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: YT4P288MB0150:EE_|YQBP288MB0161:EE_
x-ms-office365-filtering-correlation-id: 9aabbdc9-85e6-48ba-f61d-08de7447da43
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam:
 BCL:0;ARA:13230040|1800799024|376014|10070799003|366016|6049299003|38070700021|4053099003|8096899003;
x-microsoft-antispam-message-info:
 =?iso-2022-jp?B?SnBub29yWGhMNVZCVDVOa0J1YW10WUJHa3NtL1Q3alRsdGdjaTJETHIz?=
 =?iso-2022-jp?B?WXVoNC9uQk9yVHIrRlJ2cWdOcGlKQzhoZTd2Q2tWYjRlcDNRdE91eGNy?=
 =?iso-2022-jp?B?aUllL1NCN2gxZmhNZUlrTjJaRHpZTG9IOEtaMnVVTDZMNGVOQnhsd2JS?=
 =?iso-2022-jp?B?MERNUU40ckFQNDRWeFBBOGlaN0VicWMrdmZvMzF0c2Q5Umt5NU92RDFs?=
 =?iso-2022-jp?B?eGk3eC9ONXlEb1F5N2wxcVdKenJyZ3dNWmVEaDdXaUdDVWcrbjI3RFdS?=
 =?iso-2022-jp?B?bG0zUzZUNmp4dEx0OU91YittM2FSa28yWXZVZ2RVYkFNeENaTFlSa3Vn?=
 =?iso-2022-jp?B?eVZXYjY1aWh2aWxxdlhWdDVJeVVITmE2TUFwOUdjVW5LTXlkMDEvUkVR?=
 =?iso-2022-jp?B?M1lCUDlJVjVlVm9XemxEMXpMa3NOaVRlZEtoUVIxYS95VHNGTVRwNGhh?=
 =?iso-2022-jp?B?bkZMRHNGRDlzNy91Vk9kNlMzQ2hjbWY3UzA3ZzRWOUhUMGFWKzJDZUFV?=
 =?iso-2022-jp?B?RmZwQTBZUE9aMENPVEVNajFLRnQ3NmwzdjcrZWt4cGVzOWJzWkxHZ0p4?=
 =?iso-2022-jp?B?dXBsdEl4MlloZi84NHNhWmd5bVBQU1BHS3pLQmZSSWZrTnA3RDdtRlUr?=
 =?iso-2022-jp?B?ajV6UVFjWTcxNjIrTkZsclR4M2VMOHJWY1pBMU9qa1R6MUlHQno1aFdt?=
 =?iso-2022-jp?B?RmJjVDRGSUJZUVJ5QkpqY0NVVjZXcVNBREM2RFhKTjFKK0tONFNvY0tN?=
 =?iso-2022-jp?B?M3laeHppRnhpR1VWWmc3OUtKMExERE1Kb0Y0ZjNpd3NHNnRrTGg1OTJl?=
 =?iso-2022-jp?B?NE5abmVWSXN3azdTQnBtK1JtNjNyL1JuMHV2OHo4N0xYVWwvNTRhTS94?=
 =?iso-2022-jp?B?MnY5aklYVWVKQXprSjUrd3J2YjZaMXgyTkRCRGJNNTRJa2g2Q1NqVnpP?=
 =?iso-2022-jp?B?eUYzaTZnVFhoYjJ3MFJqbk0vWUNEVWR0UytEMTl4RWUyQ3hIRUk2MDFo?=
 =?iso-2022-jp?B?dEx3WFp6ZnBDS2EvQjBkMGRIZVJta2VuMEZ2UVgvaVF6RGFKOHBnNjI4?=
 =?iso-2022-jp?B?clVKWFFDS0Z0ejRnMzl5Rk9ncDBBTWdiTFdxRHhFbGpLL2lkenZEc09Y?=
 =?iso-2022-jp?B?cjZyckpkeW1ZSDhlOHRSdE1JMHZXL0h0L0xLRG9NRkpCQkxKZTU5RTZG?=
 =?iso-2022-jp?B?UHA4TGNxV1IxMWIxcm1LWW13TUhxTnVJSThNWVFjdDJZRXRXSDVlZTdM?=
 =?iso-2022-jp?B?Z2NOT2FabkRvYTA0MmFrQXNEbTZONTdLZWxwTDFRZXh5d0xheER0dGhp?=
 =?iso-2022-jp?B?bUR6VDNWNlY1Z3FqVWRleXd3VkNLVzFwV1BPZWt2TjVYWlBKMFpiNnlX?=
 =?iso-2022-jp?B?T2ZrZnpwMGk3WlJ1Tk1lUEtoWHJPcFF0MURwN3hwR0szVFBGNXRpemRR?=
 =?iso-2022-jp?B?TEI0YVMzdnNra3hrMVVGWnY1V0g4bHUzQzU4b1Y5MDBrSEZna3FqQnA2?=
 =?iso-2022-jp?B?clJiamVXZGUvdFFOcmZXYzM4V2JSazV4bDFkWFN3QjNwM1cxU3NEeDll?=
 =?iso-2022-jp?B?YlBvSVpkR2ZwNWwvemlheDMyeGlGeVpHYXR6TFhsbjZHQzM1YTY3L3hZ?=
 =?iso-2022-jp?B?bWxReXRCeUdRL2NvaEJHOENIUm9IaVFzU3ptN09Bdi9lREd6V2grT0h1?=
 =?iso-2022-jp?B?Nit6T3lhZ3cwYVVxSFRiVEdGS2k5S1BOT3h1NFJUSTJkNGxsZi9jYmpZ?=
 =?iso-2022-jp?B?R2FuRURBNDREUWxHeU5KN01yQ2RrS29CTkw2S21qRE9WVU1jMU1pYWxo?=
 =?iso-2022-jp?B?cTdjYnV4cDgwR1hCdEltSzREd1VOeE1ZNmpsallOalUrMmhRdFhITC9W?=
 =?iso-2022-jp?B?dW5WellPdGpWZDg3MDdvQ08yd2ErZjE0OUVVRStjbWRjclRKRXVCODB2?=
 =?iso-2022-jp?B?Tm1QajNGcEVJTFYzaFV4WG5reXpaYStlbzVQZitsNU0xMUFqS1ppMllW?=
 =?iso-2022-jp?B?RE1jNFExdm1LZnczWWpYL2JSN3B0L1BsUERWVXIvWFlkNzFTalhTQnd2?=
 =?iso-2022-jp?B?OFJiMzZkTlF2NGE0ZkFXSkJDTFJoS1ZHNFZYbjZPaituczV6UVJWemor?=
 =?iso-2022-jp?B?VHRpUmtNRHRSRmE1M203dU9oditHVVdzTzc0Y0hTSGRSdTFXdnEzVkEv?=
 =?iso-2022-jp?B?TzNMTEI0OWJ4ZGFFN0FYTFQxallKOVdVOE5ZT25vQ3h6SzVDWGUrZTY0?=
 =?iso-2022-jp?B?Qmx5SUxMT293UnNUdzlXY2NxV0hKRS9FQlJwNWtkMGZiQXRBczNwSEpx?=
 =?iso-2022-jp?B?WnVEaVVZNmd2Y0IyelZPM1VpTE5DTW1vTGdrdDY3MklqWnlXNVl6Um9N?=
 =?iso-2022-jp?B?WHlzVVU9?=
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:YT4P288MB0150.CANP288.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(10070799003)(366016)(6049299003)(38070700021)(4053099003)(8096899003);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 2
x-ms-exchange-antispam-messagedata-0:
 =?iso-2022-jp?B?RXlkajllNkNwQXFnUkJWVmd0OFZQdnF4b1d1ZDRkakNHS1M2d1FWeTdR?=
 =?iso-2022-jp?B?RmlYZGgzak90bVZVc0tiZGhkTVE2TDhVTVZhc3RYK2NpNURhWXk2Sk9o?=
 =?iso-2022-jp?B?QURucHhwaG01clJ1eXJlNmVXREF3ZnFwd2YrSVBPR0JTK1ZMMjE4Zm9Y?=
 =?iso-2022-jp?B?UjhMTUdmWmJGUDJyVVd0RzRjVGZEUndFaHB6c2dzUEd3eEFLKzduKzNv?=
 =?iso-2022-jp?B?OUN4ayt1b1JMWVozd3pDMEo4NWRZT3BIcFhGc0gvVVZRa05kTllXT3ky?=
 =?iso-2022-jp?B?VkV3MUpDVFZBeUhNS1JJcW5GUEY2Z0JjM1U3dWtBM1FyckNZSHpCcFVi?=
 =?iso-2022-jp?B?RGIwZFJUS0NqaHpLR0xRVExHdjhjSFBEZlk2a0VUUklKeXVjUXNhbXla?=
 =?iso-2022-jp?B?M1ZzeHpiaVdsSTl0U3YvTUlEVG5MblcxYXhxd21hQWF6cUk5dUtYS1ZE?=
 =?iso-2022-jp?B?bVRva3UxR0NubkF2QzRkWThJRm1vUlpTWW5zMUpWdnVjVlVFUGRzdUd2?=
 =?iso-2022-jp?B?RnFwUitYeTF4MVFTWWRHL2o0amRBeEFHNXU0SHZBb0g3QzdSWHJPaHJT?=
 =?iso-2022-jp?B?ZU5idFQ5YWFaeHpGRWI4T0U3R09lSzFDa00wWktSekFoTjdPNUtIamMx?=
 =?iso-2022-jp?B?MXdqSG1QdlBzMFZCT3NKdTFJMGM0RDM0OEs4MCs2RVdwNkVIVDJpcjJy?=
 =?iso-2022-jp?B?cEl4VFZjYnRjTUpiTWRaUG1zUjEwTEMvMjdOMnRlSm0zSERXU0p3citx?=
 =?iso-2022-jp?B?OEZ3Z0JUcmZackFpem1Iclp2L3FhdGZNK0tiaHN6cjZNWVpSbUIxejZy?=
 =?iso-2022-jp?B?WVBaYmUrZ1AxdlBrMCtpeXhZWGNCRWgyQzhHbmFFZERXQ0prMVVLYWdM?=
 =?iso-2022-jp?B?MHNBRGo2cUpyQ1o3dEl3ZXB1dlFmYVZoSlJYQzdRcnYyeGRqRUJ6Y3dw?=
 =?iso-2022-jp?B?bUgwRjJkMjhMOEs0cjhadzBrS2hkV1o1b2lGNC9DRjJYakZFamI4NVV0?=
 =?iso-2022-jp?B?K096c0haV1N1dDdYSHdhL0oxYTFuVjRRaFNLSGdLTzk0NXZWam1VMGo1?=
 =?iso-2022-jp?B?Y3N2V2dxbHVxdjJYSUp4Rjh4YUdRZzc3UVFnNENXVzV4Q3NxVTNpdFpS?=
 =?iso-2022-jp?B?VUtkMjZmeGQ4SVBXWkJDQkZlZG1ERGFKWHduRmphNkdFbG9MN29QL1o1?=
 =?iso-2022-jp?B?UmFWZGQ3NTBLdTFMRDNkZ1VWL1Jwd1VBVi9odDdUejl4UnBVY2lWWkh3?=
 =?iso-2022-jp?B?YTBKekErUmRZYmRPYi9mcFJmWWsvVWVNQk9BWG9yNWM1YUdHbngxTC9k?=
 =?iso-2022-jp?B?cXJUR0tjOExpWGs2MGhsZXZjM01TamhiT2hsSHYwQ0FpUlprcUJFdHF2?=
 =?iso-2022-jp?B?cGNvelZGOERtVkN6Q0hHUTcxbFpTVE9vUlFoSDJKSm5RcTNMcEorbzNF?=
 =?iso-2022-jp?B?bFUyZ1BHbEo1M1doK0h4QTI5QVVOVXh4RzFCZTRkOWRJd3ZWTkJTbW9T?=
 =?iso-2022-jp?B?TlJFWjhlN3VReGl4V1FZNFp6cVRXMVc1S2ltVWM3NENORkp1M056cG5L?=
 =?iso-2022-jp?B?QW1neFF1VlNLTmhOZXV5MW82dUJvTkdzZEg2elN4LzBuUEZobFM5dHF0?=
 =?iso-2022-jp?B?OTZBd1FnekpRVFVzd0JWemZUamRKeHFBQXJHT2pRbFByaXZEZXErK0k1?=
 =?iso-2022-jp?B?R3Y1UzVHM256b0g4cUhLcDhlSFU5L0UweEFjVngydmxOMjhWWFJLTEhK?=
 =?iso-2022-jp?B?a005U3AvbEdCczV4Y2VFUTViY1RxK0lJNzdKamVzZUkydm05dHd3TSs0?=
 =?iso-2022-jp?B?eUdBUWZJeG0yNDRZaWRWOTl4S2VKN2NRbkpXV1pUcW5KR1VJcFpRMlh5?=
 =?iso-2022-jp?B?bVAxL0hrL3B5bzJkUkQ5RVlySzJyVHNvdW1RV29xaW9SZ0lrVVF6UlEw?=
 =?iso-2022-jp?B?Qlo0YVRkcXJ1eWhjQ3Z5aVc4ZC9ZTTBHMzlsWXlsNHZKNkRvcE42UXZx?=
 =?iso-2022-jp?B?NUFyV25BeWx1N09INU1yb1JmN3BCZm9HNkFtYVY0LzdFeW91Q2ZBR0tm?=
 =?iso-2022-jp?B?T1FvMWlLZVJveTJvQTFtbEtoMjE5ZzVma0dLUHZSVEp3eStnanYxL1Vz?=
 =?iso-2022-jp?B?clJqK2xFeDZoTXhSTldtY1dRZUEzbVI0NjNYQm92RE4vTUw3WFZ5a1px?=
 =?iso-2022-jp?B?eGFvRVp0TjFsUEpXNCtWZzRaalVnVStHb1hGaWp4UEhaTFNqbVUvSndV?=
 =?iso-2022-jp?B?cTNNNjliSmdxSGUvV3FKTWcwM2NBODBpMVNjUzc1Q3hoOW9PUXJRajZX?=
 =?iso-2022-jp?B?N2xQalBaVi9ydVNYTEY2Ty9LUEZEd2lSRTdHcUgvdFFXejF4RkJhUzdm?=
 =?iso-2022-jp?B?ZFhOeGNhaEwvYTQ1eXRJVjVLM01SZzQ4R3JoTXJsUEhhQlhsV0ZzTTRx?=
 =?iso-2022-jp?B?TEJva3AySG9zRlhaM21IK0dYTWk4Z3BSWnd5VVh4ZVpoRVZjZWNIUEZk?=
 =?iso-2022-jp?B?eEdUc0xYYWtmeUl5VlRlSG9saTlBN1JQRENFV3Fodkh1VEkwZjBPVy8z?=
 =?iso-2022-jp?B?YUlSOTZqMDhiSTFBUlBWeFlSS0E2bFRQTU5aT0ZqZTFTYlda?=
x-ms-exchange-antispam-messagedata-1: 52t+xHYnIq5QwOw/EtBkrV93gGIkSCakwAI=
Content-Type: multipart/related;
	boundary="_004_YT4P288MB01507D63F23F6B505AEB759E8375AYT4P288MB0150CANP_";
	type="multipart/alternative"
MIME-Version: 1.0
X-OriginatorOrg: srmsoftwareinc.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: YT4P288MB0150.CANP288.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 9aabbdc9-85e6-48ba-f61d-08de7447da43
X-MS-Exchange-CrossTenant-originalarrivaltime: 25 Feb 2026 08:28:28.6307
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9c59d1d5-34ef-41ab-8675-3006281ab1ce
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 46sECtzaAz2/Ds111+R5YntDOXQd2YTi5IZY1Zr0kSGIIzv+GwtYJ2NCSBYMYP9CLcjSORWyfzzN0866tWYFjhi9GFu2FLdT5zOctQTMraem8WDrvFt/fwJ/L1HZ7wXx
X-MS-Exchange-Transport-CrossTenantHeadersStamped: YQBP288MB0161
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/YT4P288MB01507D63F23F6B505AEB759E8375A%40YT4P288MB0150.CANP288.PROD.OUTLOOK.COM>
Precedence: bulk

--_004_YT4P288MB01507D63F23F6B505AEB759E8375AYT4P288MB0150CANP_
Content-Type: multipart/alternative;
	boundary="_000_YT4P288MB01507D63F23F6B505AEB759E8375AYT4P288MB0150CANP_"

--_000_YT4P288MB01507D63F23F6B505AEB759E8375AYT4P288MB0150CANP_
Content-Type: text/plain; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

Hi Team,
I would like to report a timezone-related issue we are encountering in our =
PostgreSQL database.
We have two columns:

  *
empjob_utc_update_date
  *
jstsk_lst_end_tm

Both columns are defined as timestamp without time zone.
Currently, we are observing the following values:

  *
empjob_utc_update_date =1B$B"*=1B(B 2026-02-19 06:26:23.830811
  *
jstsk_lst_end_tm =1B$B"*=1B(B 2026-02-19 01:23:46.016

Our entire application runs in the Canada/Pacific timezone. However, when c=
omparing these two timestamps in our queries, we are getting incorrect resu=
lts in the system.
It appears that:

  *
empjob_utc_update_date is effectively storing UTC time.
  *
jstsk_lst_end_tm is storing Canada/Pacific local time.
  *
Since both columns are defined as timestamp without time zone, PostgreSQL d=
oes not apply any timezone conversion during comparison, which is leading t=
o logical inconsistencies.

We would like clarification on the recommended approach to handle this scen=
ario. Specifically:

  1.
Should both columns be converted to timestamp with time zone
  2.
Give me best solution for without even changing the column datatype.

Please advise on the best practice to ensure consistent timezone handling a=
nd accurate comparisons going forward.
Thanks in advance for your support.


Regards,
Nandish Bhuva
[cid:ba34352d-4c57-4251-9073-5b946953cdbf]

--_000_YT4P288MB01507D63F23F6B505AEB759E8375AYT4P288MB0150CANP_
Content-Type: text/html; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-2022-=
jp">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
Hi Team,</div>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
I would like to report a timezone-related issue we are encountering in our =
PostgreSQL database.</div>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
We have two columns:</div>
<ul style=3D"text-align: left; background-color: rgb(255, 255, 255);" data-=
spread=3D"false">
<li style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, C=
alibri, Helvetica, sans-serif; font-size: 12pt; color: black;">
<div style=3D"margin: 1em 0px;" role=3D"presentation" class=3D"elementToPro=
of"><b>empjob_utc_update_date</b></div>
</li><li style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontServi=
ce, Calibri, Helvetica, sans-serif; font-size: 12pt; color: black;">
<div style=3D"margin: 1em 0px;" role=3D"presentation" class=3D"elementToPro=
of"><b>jstsk_lst_end_tm</b></div>
</li></ul>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
Both columns are defined as&nbsp;<b>timestamp without time zone</b>.</div>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
Currently, we are observing the following values:</div>
<ul style=3D"text-align: left; background-color: rgb(255, 255, 255);" data-=
spread=3D"false">
<li style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, C=
alibri, Helvetica, sans-serif; font-size: 12pt; color: black;">
<div style=3D"margin: 1em 0px;" role=3D"presentation" class=3D"elementToPro=
of">empjob_utc_update_date =1B$B"*=1B(B&nbsp;<b>2026-02-19 06:26:23.830811<=
/b></div>
</li><li style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontServi=
ce, Calibri, Helvetica, sans-serif; font-size: 12pt; color: black;">
<div style=3D"margin: 1em 0px;" role=3D"presentation" class=3D"elementToPro=
of">jstsk_lst_end_tm =1B$B"*=1B(B&nbsp;<b>2026-02-19 01:23:46.016</b></div>
</li></ul>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
Our entire application runs in the&nbsp;<b>Canada/Pacific</b>&nbsp;timezone=
. However, when comparing these two timestamps in our queries, we are getti=
ng incorrect results in the system.</div>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
It appears that:</div>
<ul style=3D"text-align: left; background-color: rgb(255, 255, 255);" data-=
spread=3D"false">
<li style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, C=
alibri, Helvetica, sans-serif; font-size: 12pt; color: black;">
<div style=3D"margin: 1em 0px;" role=3D"presentation" class=3D"elementToPro=
of"><code>empjob_utc_update_date</code>&nbsp;is effectively storing UTC tim=
e.</div>
</li><li style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontServi=
ce, Calibri, Helvetica, sans-serif; font-size: 12pt; color: black;">
<div style=3D"margin: 1em 0px;" role=3D"presentation" class=3D"elementToPro=
of"><code>jstsk_lst_end_tm</code>&nbsp;is storing Canada/Pacific local time=
.</div>
</li><li style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontServi=
ce, Calibri, Helvetica, sans-serif; font-size: 12pt; color: black;">
<div style=3D"margin: 1em 0px;" role=3D"presentation" class=3D"elementToPro=
of">Since both columns are defined as&nbsp;<code>timestamp without time zon=
e</code>, PostgreSQL does not apply any timezone conversion during comparis=
on, which is leading to logical inconsistencies.</div>
</li></ul>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
We would like clarification on the recommended approach to handle this scen=
ario. Specifically:</div>
<ol style=3D"text-align: left; background-color: rgb(255, 255, 255);" data-=
spread=3D"false" start=3D"1">
<li style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, C=
alibri, Helvetica, sans-serif; font-size: 12pt; color: black;">
<div style=3D"margin: 1em 0px;" role=3D"presentation" class=3D"elementToPro=
of">Should both columns be converted to&nbsp;<code>timestamp with time zone=
</code></div>
</li><li style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontServi=
ce, Calibri, Helvetica, sans-serif; font-size: 12pt; color: black;">
<div style=3D"margin: 1em 0px;" role=3D"presentation" class=3D"elementToPro=
of">Give me best solution for without even changing the column datatype.</d=
iv>
</li></ol>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
Please advise on the best practice to ensure consistent timezone handling a=
nd accurate comparisons going forward.</div>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); margin: 1em 0px; font-family: Aptos, Aptos_EmbeddedFont, Aptos=
_MSFontService, Calibri, Helvetica, sans-serif, serif, EmojiFont; font-size=
: 12pt; color: black;" class=3D"elementToProof">
Thanks in advance for your support.</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" id=3D"Signature">
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
<br>
</div>
<div style=3D"font-family: Arial, Helvetica, sans-serif; font-size: 9.75pt;=
 color: rgb(34, 34, 34);" class=3D"elementToProof">
<span style=3D"background-color: rgb(255, 255, 255);">Regards,</span></div>
<div style=3D"text-align: left; text-indent: 0px; background-color: rgb(255=
, 255, 255); font-family: Arial, Helvetica, sans-serif; font-size: 9.75pt; =
color: rgb(34, 34, 34);" class=3D"elementToProof">
Nandish Bhuva</div>
<div style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, =
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" clas=
s=3D"elementToProof">
<img style=3D"max-width: 780px;" id=3D"image_0" data-outlook-trace=3D"F:1|T=
:1" src=3D"cid:ba34352d-4c57-4251-9073-5b946953cdbf"></div>
</div>
</body>
</html>

--_000_YT4P288MB01507D63F23F6B505AEB759E8375AYT4P288MB0150CANP_--

--_004_YT4P288MB01507D63F23F6B505AEB759E8375AYT4P288MB0150CANP_
Content-Type: image/png; name="Outlook-bfpeekv4.png"
Content-Description: Outlook-bfpeekv4.png
Content-Disposition: inline; filename="Outlook-bfpeekv4.png"; size=4808;
	creation-date="Wed, 25 Feb 2026 08:28:28 GMT";
	modification-date="Wed, 25 Feb 2026 08:28:28 GMT"
Content-ID: <ba34352d-4c57-4251-9073-5b946953cdbf>
Content-Transfer-Encoding: base64

iVBORw0KGgoAAAANSUhEUgAAARoAAABcCAIAAAA+p+0oAAASj0lEQVR4Ae1d32sbxxbOo/8i/RN9
8T/gh4Kfoze/qH0UJnk0ap5kqIMxJVhgqkIqQwsShhinoBuDeytd42vWoVUc5FStIkvX15kr+ODj
MLsz2l2tIun6BBNmz549c+ab883vXT0y+k8RUAQyQuBRRnbUjCKgCBilkwaBIpAZAkqnzKBUQ4qA
0kljQBHIDAGlU2ZQqiFFQOmkMaAIZIaA0ikzKNWQIqB00hhQBDJDQOmUGZRqSBFQOmkMKAKZIaB0
ygxKNaQIzIdOg+GoFXRqJ2eVRrO4d7ixXZV/pYN67eRM60YRWDoEPiudmu2gdFBf3dxdyZc8f2OC
DYajpYNSHVYEPgedWkGndFDPFcoeCvGW9ksalMuLwGzpdHR6vr61T6r4E7lCuRV0lhdK9VwRmBWd
WkFn4qBOsitXKF9d32h9KAJLjUD2dBoMR8W9Q0mVOOmj0/OYOP7399/vLi7wd//hQ8ynVE0R+AwI
ZEynZjuIOUeSHKs0mv6ifrq9Hb1+/fHZsz+/+ML6662tfXz27D9nuhLoh1Dvfg4EsqTTTu1YkiRm
en1r31/QYaPRW1uzWBS+/Ovx47uLC78pvasIzBSBbOg0GI42tqsx+WOpeZYfPt3e9p8+DTPHI7mt
VGaKlxpXBDwIZECnwXAUf/nO4lLpoO5y7tPt7d9ffeVhjutW/+lTl02VKwIzRWBaOk3DpZV8qdvr
RxYvNZfAscHz55FmVagIzBSBqeg0JZc2tquust1WKq7OJ6Z82Gi4jKtcEZgRAlPRqXRQtwZviS5d
i+N3FxcxOeNR662tfbq9nRFqalYRiEQgPZ1qJ2eJyBNWdo30ki4/uEg1/PHHyDKrUBGYEQIp6XR1
fROmRyLJ6uZuZJHuP3xw0SOpvLe2FpmFChWBGSGQkk6pl/JIueLeYWSRho1GUtp49HUnKhJkFc4I
gTR0qjSaZEXqhOskROTRBw9h/Ld0vDejuFGzkQgkplO3109xjCjMOhedspo4gWa6qxtZ6yqcEQKJ
6TTlah555ToM8dfjx/4OJ9Fd3dKdUdyo2UgEktGp2+uTD1Mmmu0g0qE4x/PiM0rpFAmyCmeEQDI6
pTvkGkm8RR7s8TsWlUaz2Q7ki1hX1zetoGP9hVf8LTW8qx8p9NQr3Dg6PUd2kZrSpvSTyvgsBx2W
rspnqYAETHV7/cisw/KwxBiDZ2WO8MpySeZIt5HALf5v3ZWXjDEII/0xxkBuAdXt9ZvtoNJoVhpN
5CUtJ0ono1MmsyaU3EWn+S5FXF3fRL71mCuUAavrpO/GdlVWkmUEXbGFnmu4a4xxuSFBi9RZ3dyV
btROzqxMAT6ydpVlJV/CgZWj03PoW5TAuq481II33OTLAc12gGfDS7itoINb1v/jz+/wGyGuKbrM
VAY6TUHI1TLrqADk0gjLSAtISOPx0wno5MrY8iPmpSuY5rtQbtFAlgWYTgxBqMkHV/KlSqM5GI4s
oeerGNyHWN3cxTee4JikE12FDmkjN/SoY2Udk070WboaKYR96Z6cY5MkAId04uer6DwzIh8szyUT
ZJRTDUI+niuUZe4WneTkhc4ANGk8fjoBnVK8Y8tChhOykNLdOW7j+vem4aSHTjzRy4BjqUsHdcYQ
hTL4JALGGOjs1I4tOS9pTba+bO/QGbI4rpYrbI0SJlDpMojZ7bAbpDOUDIYjMmQlX5JOYhCIAjIX
Hv5kRoh72d1ROTJBVHGXdFrJl2T3aNEJk5dcoWx1v5FZxBEmoBM9nj7hCRRjTFZr5Uk3nRgWK/mS
y0NJJ+Ar55MIXGkHWG1sVxnrRM/zcgp0PDRwRZvsxOjGxDjwaPIoGZs/lpdm4QzHw8YYFhZwyYCO
pJMxBmYtOvGSebkSRBUKkk4r+RKRtOgE91x17crLI49LJyJOv1Mn1rf2WTeRns3rCKws4+rmLuam
mJ7SzzCdZM256JQrlKUaoPPECpp2TzWHOw14CDnCl8Wh866ER5PDIfYwHIhybRYS2TrQDfJK1nhk
dhgcEhMr7l2eU85ohASPr2/to30Zj4fhgGUWT3GESWupE3HpFI4GFiBRQk43PU7P6wUNV1kY2ZJO
GG3LRzDaYYsubzEKKfSMZJjLuOnhmF7WOhTCw0UZLoxaWtjYrhb3DtlUE39qUiIT8BwUJbtW8iXw
hyNbsouSo9NzmaZNZsclu2Y7QNyzH0NBxjMf6TxrgaaYIKqQEAcOTYEV5VDDU2FAaDZpIi6dWMH0
O1EiVygX9w7Zwk30cl6vD3qKieG1R4GjHdRZHHxcODAILCPkTyI6uYwwd8Y3JTLB1mEwHLG3WcmX
UF66yv6HOpCwp6JNZmc5tpIvkZMuDGnEStAU5JI2cGAlX7q6vpFyzlHnQCc0HnQ6MrG+tY+hUSYT
u9SMmuZV3G6v7yIMatp1V65Qy0WtsL5E0ooJednt9fEN90qjuVM75qAFOi46ySETo5ajVlftUFM6
wDR7pKPTc9jnMgO+ks2FdTyC8F3f2kfnw7kW+cbs0PMQEHLJGIO4l0Nu7L/RKyvBgIRc0obrIhvb
VSknnWS+ltmkl3F7J7obTqDMmVDI8j7zT6/EBw6hAPRRZPQMkh5shjnygf9Sh8FE3KTN+O0i80IW
kjYSNGSNYRijVipEpidqcryH0Ce9+cV5DkTJPZaXCY5NrOzYv0k0rLiPdFsKmQuE1uPsYOE/Z2go
F/t8aTBdOhaduORKp5HIFcrEMV32cZ4avX4d5+TRxA+DoZXy53h0es6t8VbQ4TgBe0fGGEkVY4yc
EbFBoXB9a58VCcTYQOJSBpDfMcYc1BAu1qYKJyqIDytqPfYnaqIU7JSurm/CEthneeWcBw9yXhTO
zopy9k6Me4/zuMXIxKVFJ6viaJYd6UT7MRVi0Ynlp9NYzmf3HTOzadQ8n60cPH8e57OVYILfB8kW
WVgutkoFYwyjR3ZQfHBju2pBh5UAKrDBtrziGRlO1klRaLKBwxJ8K+g02wF1sCLCrC3j4cuJmrLP
wZRJSuTGMXywVlmIEgImnB37XrYvbC+a7YAgtIIOt7asUhBSyMN0kg6TTswX9SIzgh1Mt1zVZPlg
jElJp/gZhLOcUpLuo8ocdLnqA15JtrCGVvIlRoxUwBkwqrGvoGSndsweA0J0fVRwDTMQDVRjIrwY
zVtMcPkrHLUu5ONokqv0ISxhyFpjFsoRNpHZWR0Ue2OWCwkywSoL1SAP04k9njXTkxVKIyv5kseO
lbW8TEynZfydCzZC7GQkBDI9XtsN41vcOyQJxwzhMAYPSkmzHWAxAzqIHuqjs8LAQypIB5ButoON
7SoiDHW8vrVfOqhbw4HayZn0dmO7KieHV9c3yCVs35LE0QQyLAL2amGfXQrc3tiuctzLjMbOY6CL
E4lhx2ifz/JHjHjSamO7ysaClpEgE3AJa2Fl/DafJUcN0sLGdpVNhsuOlTsvk9FpGX/nQnJpIp2I
iyYUgRQIJKNTzDHe8O7+8uZW/qXwLJNH5Jo1mh82fpnYVyOKgEQgAZ2sLlJaQXp4d//qsvek8fbL
7y/Cf08ab5tv/x7e3YcfnIXk6vqGg3v24xwTzyJHtakIxKJTt9e31mrCwL267OVfXoZZZEnyLy9f
XfbCj2co6fb64U6JjMowIzWlCFgIxKITpo/Wk7wc3t1/8+oPizb+y29/eTeLburq+sZDJLlAR+et
BPadKo2mf1jbCjrhJabBcMQVC5rt9vrWoQTekgms+EmJKw1rrrvTyD1lj58pCxuGwvJtooKlb122
gk7MvGRNRVacZXmay7h0cuUxvLt3je78jHrSeJsJo1pBB4df5DoY+yIrIZENlwjvt2LzwV/ZkbWC
9TFjDFfVx4t4eJG7dnKGV55cM7fPQydP8bu9/urmLjZ5wk1JfDrhbBE2mqx1SAtwHnG05DEvK40m
IMURDc9TstSRFed5NumtqeiUmktg2pPG25juDoajSqMZOReyCOO/dO3zwA0La/ZRpYN6sx0U9w6x
zIrDY6gkyvFJiZ3aMd/bkYREU4qfOcUacbfX59IwghXGsURb3DvEyjI2cLAgXjqoY1cRpZDCwXAE
fRgvHdTBW3wCAaVb39rHAW3swGA5mE62go41Nx6/QUwd9gNYiIcy/ZcPApbBcLS6uXvyz3/z1k7t
mMvx+BAAJHAbWxFU2Kkdd3t9AEJlFI1UlwzPFcpHp+dY796pHbeCjkSP6+y1kzNWMdDDJjiaYxy3
Pzo9B/iD4YhbICzFxHCdik4//Nr1d0ET7/7wa3eii5EfRfDTxnVXbsuE820FHQQce5LVzV1giuOS
2FbCzhviZn1rv9vrY27JqgoveIBO6KMwtas0mtz2RXzjBXicu8fZapyKQpANhiOcN0UYIUd0fXgE
b5GVDupotsFDeYqf7uHwFI50MFDQOyGkaJY6yBTbSsaY0kH96PQ8VygDEFleALi6uYtuij0DNp1I
Bmy+wRMc9gUBjk7PUbT6mzZ9w2Euq77AdhR2p3ZcaTSLe4doRMBAUBrb6FfXN/j4BEHAkWW0CDhk
jMYORkoH9drJmRxlWLm7LtPT6fLmdiJb4ij8ObhzOYc5G4+KuUgSX+4aa8GBVtDhOWhoYtCCNIMG
W5njxhK/uYhnN7arp+dXiB5qslwc6PP9JRwUoAIHewhcWsDOLDtVnNmHMoUIaxyTKe4d1k7O0Gci
kjjiYiSxXZf+c1wqSQshmIDsEIVoCHC8AC6xIEAA5Ky/aUs6HZ2eo6MYdzvIGrDg/Vx0PhvbVWxY
X13fgJngBtMkJIiEsmDwQkCIHnoqXpLhNL66uctTmmzUmGC3xkxZTFciPZ2+/eVdHLZM1Hnx5r3L
ObRh8dni15y4OMmAgz/4gAF34lkr2AtGoNDm6uYuH6cmy8XeiVWO7o6x7qEThi440FTcO0QAYdGF
4Y7X79i3GGNwOpmnTnkWwRjTbAdo+MEcOokEJ1FShwysNJqrm7sYkbLs0gLplCuU6/9oQ8fiLaIc
rRIAAXTy9AltMmtZBEZ8pBpf98bYYUx74CzrSDpvgW8Zt5xnjpGJlHT6c3A3kSfxFVxrEjzo6edJ
zLty8BCJBYYxaCYxCxqPQEAqHjNDi4VhGBrm9a19vuiFYML5IE5L0PpWGk0OqDBk36kdo9EFSXBU
B9FDQsJgce8QuWCGhk9ZUHh0es6TH5hF8GsNVrMKIxjV0CChQM+ZK5RRatrH+kSuUMaUBu/hIebY
ftMISrS6uQsmo7eBGqdGOFsTphO7L/RIqAh0IEij40JekmYWAY5Oz1E6+JArlHOFMsbtqDi0O/AK
w2MJPq1hnL++tS9bJZY0MpGSTs23f8dny0TN3959jHTOdRI0Jn8sNRnfkdn5hQxxv9pc7jK22ENa
I725ePUAM01Jpxdv3k8kSXyFn//1IRL6DOkkO/fIvCYKF5lOzXaAr7uw/cZq1cRCqUK2CKSkU9J9
Wz+1vnn1R2SpMqSTNexBdt99912xWIzMOizkuenwrUWQ8AvJmCeMD7ZzYrYI7j0QHx4EnVwrnsVi
8dGjlAg8kPjQYiZCIGUwLVfvFNk1JYJJlRWBOAgsBJ2+/eVdpK+ZDPZcXVNkjipUBKZBICWdpj8P
IWdTrqUI+aqptUwX/9J/EmIa7PRZRcBCICWdPs9C+fSH9OLvGFi46KUikAKBlHQa3t3L7mWadP7l
pcvv+F1QpOZ4S1FXt1zYqnwWCKSkkzEmq60n1yEj17dsIpkTKVzwpe1ZVKfanC8C6emUyTmj/MtL
1xFYfsorkioThda3qeaLsub+QBBITydjzM//+jDNMO/L7y88L7pPc5CcH3Z6ILWoxVwQBKaikzFm
mg0o1zCPJzgndkGRCsqlBYmtB+jGtHRK/UKuh0t4PzySKhOFyqUHGMSLU+Rp6YSSJF2W8L+Ey9cN
JpLHUojzCsbiQK+e/P8hkA2djDGXN7df/xRMnEp98+qPy5tbD454I8XiycRLvufjsay3FIFZI5AZ
neDob+8+vnjzPsyrr38KXrx57ycSLMjfgJnIIiisb+1P+S7TrFFW+w8EgYzpJFHjR5Wl0J9OcUhP
vi7uN653FYFZIzBDOiV1PemUiV+uSZqR6isCM0JgUejEX9SKM8DDh7tmhIiaVQRSIzB/OuGTi3FY
NLsf4U0Nnz6oCEgE5kwnfNrOzyV8500XG2S1aXoxEZgznfAJHn6yEF9sghAfwVpM1NQrRSASgTnT
KdInFSoCS4qA0mlJK07dXkQElE6LWCvq05IioHRa0opTtxcRAaXTItaK+rSkCCidlrTi1O1FREDp
tIi1oj4tKQJKpyWtOHV7ERFQOi1irahPS4qA0mlJK07dXkQElE6LWCvq05IioHRa0opTtxcRgf8B
oWpnVjMuEHkAAAAASUVORK5CYII=

--_004_YT4P288MB01507D63F23F6B505AEB759E8375AYT4P288MB0150CANP_--