Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vxMth-00AbKs-1h for pgsql-general@arkaria.postgresql.org; Tue, 03 Mar 2026 10:22:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxMtf-006KDu-30 for pgsql-general@arkaria.postgresql.org; Tue, 03 Mar 2026 10:22:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vxMhq-006Dm7-2E for pgsql-general@lists.postgresql.org; Tue, 03 Mar 2026 10:10:23 +0000 Received: from mail-canadacentralazon11021119.outbound.protection.outlook.com ([40.107.192.119] helo=YT5PR01CU002.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1vxMho-00000000A6U-1jNe for pgsql-general@lists.postgresql.org; Tue, 03 Mar 2026 10:10:22 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=KpW8v2dgj6UZr1EWZVUJDU3sA3o/gJ/JFnM019pV1YpVFM6Qkwhd/wQCF5HCPAdJpMK5ZSr0OKrq2vEUwjZBKktIlSX1FjQ/ESFWmAPnECZRDgr3OfGRAB0SI9y3xlqZXh60lILp6SOmavFgMBT2ETilIxxismbZzWw6yIenxeqR7WtRp1kc7BTjB+niXEGvNWRGlNPMjaH7xksxqeE7iTQrnk6xVmknQ7h7ckTlXcmx2c0HrfkRfMyzY6fThzVEDnlYkXZR9fPQ9iloPkbCsrxB3iSU16k3qfBD0CYj1n0ysTWg+C+F1SA7InQdd5GMB9+HzTlGpgcZ18p7qVw8yQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=i3d5qqQrfTW3KdGyHB5UXNVsbpc6R0EGD8F8kVyoMjE=; b=jkRylrgXIigxfu1VJAH8ZINB/LAdvTcTjaZeIv1I65gFr2q3LVYUw/X9mHX895DrvynpG8CFhvtheOZyO+psh+9p2PL0I6uCDI1HQ+hRDoZ6OAk5RHX8VG/85uyyDl38kx/MgxDq6ayQIvuF4IrB7N7k68RAesLvTXxKCZc02Nw/Y9b6b3EdBfwq3IlQpWItdM7Lf4bwHvoRNBcBFzftYxwsq3Bz7jCnEvJysFgpJdEj1bayj+9c/Y4VpIXu9dizScqL2q96rxOun6RxJoiUXcdCKzPib+Kc5fhDdvks3uyTVAMb2jLmE+6BOPmD8YNtmKPPzWvPxYy4ePbLCSFpPA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=srmsoftwareinc.com; dmarc=pass action=none header.from=srmsoftwareinc.com; dkim=pass header.d=srmsoftwareinc.com; arc=none Received: from YT4P288MB0150.CANP288.PROD.OUTLOOK.COM (2603:10b6:b01:104::12) by YT6P288MB0770.CANP288.PROD.OUTLOOK.COM (2603:10b6:b01:11e::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9654.22; Tue, 3 Mar 2026 10:10:16 +0000 Received: from YT4P288MB0150.CANP288.PROD.OUTLOOK.COM ([fe80::3fd7:fc75:b034:259d]) by YT4P288MB0150.CANP288.PROD.OUTLOOK.COM ([fe80::3fd7:fc75:b034:259d%6]) with mapi id 15.20.9654.022; Tue, 3 Mar 2026 10:10:15 +0000 From: Nandish Bhuva To: Laurenz Albe , "pgsql-general@lists.postgresql.org" Subject: Re: Timezone handling with timestamp without time zone columns Thread-Topic: Timezone handling with timestamp without time zone columns Thread-Index: AQHcpjB1s/2fqObN5061HSQqqhbODrWWp28AgAXoVaKAAA+RLA== Date: Tue, 3 Mar 2026 10:10:15 +0000 Message-ID: References: <8c3b8558fc3322c31d9f05517dcdb43e16296fa0.camel@cybertec.at> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: 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_|YT6P288MB0770:EE_ x-ms-office365-filtering-correlation-id: d9529ba5-d31f-4d31-fc65-08de790d10ca x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|6049299003|10070799003|1800799024|366016|376014|7053199007|8096899003|38070700021|4013099003|4053099003; x-microsoft-antispam-message-info: eHUy6/m6hBWsMSoTuLZTfb5czUSUxs9dNdycQWehIz0CK664k1/gAUrk9BA3E+WRQaJ/fOHgCiakt3fajYa187/axCT5uhTqom+VTP5clw0NO6DxZCPzW9fwp+4WNbuJrjvsGxWtovf5WrYSZIv0wG84HY43zUJYF9qU3IX1ts9if9Uqmsy6dY7+NF2t5EbCDlORH1YqT12xoTk5hSTiYT7xa1XGLybaXdIRbtv2MpVU1SK0n5AWXQUwnYa9LzLOl5sEP4eYKxuqYOktZe4FCLH/hObNdU6LkdCxIIG0674krtYwhcauyPa4LsUcn2uNWltjLeHgaK6nvcn1UbjGhaL6dVpjxe1wylgNjtHipQCMyzlp9Y8es9+5WvI1VEWQafb289WDHq+kcCda/lykmJbg1j1L1gXd0Q6xRkYgNJbiE/BlulOq0Poz5i4DVLQmInVLL/gZCwgx63rU8qWh4/tv7QrLTA8HLZyfcU99iD+Ic75BJVR9Rg+gsCuIDdRCXUG8ER0CLYwxpUokr2otlYnmR5faakNnhvC6FTD6BTADx8IwOPmbzX1ljZi6nvGP26Rk23jIfSMvmrGzbjpaklY0v4RVhvmQgmUOxlm/DSiKM26ZAPVDjbFhhxiO0Z/qeQQAYJnP9W+v8q8VHpCIIH5gjrZMKZ0seoacMdPldgS+VrmCsU2T4pcUUYiB2f+0wKqpDUVBQV9kxgGq3breVCEnbvimrkhtBtXS8v9rLoZX5aptK7Clt+VtrfDyQYrPyxRy1PByujv4UrHn+/L6t/OOuz5OmwhwSqiAOYm+EnQ= 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)(6049299003)(10070799003)(1800799024)(366016)(376014)(7053199007)(8096899003)(38070700021)(4013099003)(4053099003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 2 x-ms-exchange-antispam-messagedata-0: =?iso-2022-jp?B?ckZUNGhJOUR3bXl2eVo4dk43Z0lFM1hyWjhJUEVyNUkydEpOMzZjdXRk?= =?iso-2022-jp?B?cnpoMk5OVW92OTNFT3BLczlKd0E2YXJLQVNyV2IyYlBBOXhwbHo0QkNS?= =?iso-2022-jp?B?SEdXMlc3NUgyNGNHVjFWenBRVEs5U1lkRGFYSWdieE5iYlpFQUV2Ykd2?= =?iso-2022-jp?B?cTJDUGpLT25TWVVRVHcwN2VmZWlZdDlZNldjZmU5ZVc5amxhNVBuU1BY?= =?iso-2022-jp?B?bm1QcFd1MytWZXl5R2R3SnJmc0hkcDByT3kzTStpTDBPWTNYM1pwMjBk?= =?iso-2022-jp?B?YytYUGRUUnB6Q2gyQi9keDhjUTUrdkJzZ1VnMjBHbWM5Q2JxMGJYM0lE?= =?iso-2022-jp?B?Y0p0SkJRaTlFa1YrVlhKb2FlQ2R2R2lMNDJRL1pjZ3ErYy9vVEtRSkpW?= =?iso-2022-jp?B?ejF5WWlmSnBRemdNelNWT25HS3BJSTJWTnZtSTJQWThlRk9GTjRTVllh?= =?iso-2022-jp?B?Vm9nc3lMS2FmTElPbGh6MUlIYXNEeDdSUjVianN6d3Axa2d1N3VmaFA3?= =?iso-2022-jp?B?S01DdUJ1eUYvRFdLSi84bzAwZjhkYzRUQlY3V3ZnZHVZdTh3Vnd6ay9F?= =?iso-2022-jp?B?UXN0U2E2eTlOZVVtVWQ0L3pqbXZKeWJYd01RTVY4cm84OWJiN0NTSFhu?= =?iso-2022-jp?B?SzZIZzN1VnBvd0hiM2RvY2N1SHJJN0RuU1ExM2dSSVNOL2s5SUZnSDdh?= =?iso-2022-jp?B?clpyY3FyWDRtZUNTaDc1VUY3UEtFMHRVcVUrWHhGeHB0MWMzZFhiWGZI?= =?iso-2022-jp?B?WmRHTTlRTnU1NktlRU45TDV6RHlycVA3RS9BM0doL1p2blFJMVU5emlv?= =?iso-2022-jp?B?VEVMWlVFNmlRcTNVbHJBTFRnV1ZNdEd5WmJtT3RuTmVINVRRVFAzaTFv?= =?iso-2022-jp?B?RWFjb2dWYi9GV3paanFEa3JuT1V0enJ6ZHRia1NLVE40SG1uVVZkclBS?= =?iso-2022-jp?B?Y0c0M2ZlRVJOUFpiendGemNxd3BYOER2UzZjd3o4b2hTcmVtNDB4MXFt?= =?iso-2022-jp?B?ZzVqT1pVdGp6N3JPeTZ0aFlPOWp0emZrRHFRWGlHQS82cVhRQmdEN3Nz?= =?iso-2022-jp?B?NWZmdi9MZUdIZmZrQzkraG5GZDBIN1dWM3JVOE9FM3RTYnRLOGdFbjVr?= =?iso-2022-jp?B?Wmhqb3lnT0YvN3dqcDMzUzBJbFRhS1JpU1ZjRTFZU1NTQ0Q3bkV4Ylht?= =?iso-2022-jp?B?KzJrOXlYUFVTajFnU3hIYVRybEV3SzdwZzhyUy9BbjhxSXZHSFJnbjZx?= =?iso-2022-jp?B?R0thTWlnZFd5T1R1MlNoYmo3cEYzRVVOQ1ZlNzVpQ3JXRW5ZbklIcU1D?= =?iso-2022-jp?B?WlM4TEFza3NIN2dFOXB5LzRocURacjBVK0lla05McU1KcWQ4dE4xZ2VH?= =?iso-2022-jp?B?MFU2NVkvUGJJTmVmdGNMZ1BEam85aGdsZjY2TkdFNW5XMWE0ampxOEdx?= =?iso-2022-jp?B?YjBNQ2FaWFViNHIrdTFMNjV3QTNjZGVJb1A5dzJpcFhISitSdUQrQUUw?= =?iso-2022-jp?B?c2U4a2MvcTdieWdsci9UbmNaS214bG53TmZnRzBMODBrM3l2WlQvVENI?= =?iso-2022-jp?B?Q0wra1BlVW5Kd0hkOW16WXlFMlJxV25YVWtpejB5WlRFMGZvM1ZkNmE0?= =?iso-2022-jp?B?dFUzdEkxaENFZTdvYjNscDJlVjdaMWNGZVFWaVdTVERTN1Ztd2lja2Ry?= =?iso-2022-jp?B?QXdWQjQxT0ZtU1krZnZOYlR5V3NnREZaY1BYdXc5ZjU4OTkraDhLaGxR?= =?iso-2022-jp?B?cUVyTXQ5TlhDNUZTY3dDeitMdTNqM0FLY1BSTzVPWUxRZDArMzVRYnNO?= =?iso-2022-jp?B?SWplQ1VoOTdvcVZncUNZWDBVaWNIc1ZUQVVudU94VlEvZ0lsMmhwYzhS?= =?iso-2022-jp?B?S2JNMmt0dW8weFAxckxiakxGR3M1STNSeTczamQxY0I3MzZRZnhqQm03?= =?iso-2022-jp?B?RHZIWk02ZExmNlJ4dm95MGpmYnQyWXVBclBtR1ErRHh6V25LRVNXY2pO?= =?iso-2022-jp?B?VTNjamVweGgwMHpOTVMvcGVaZG1BR0FMckNwQWFnODYwMlR6VmRmUVF5?= =?iso-2022-jp?B?Zk12WldVZHozemh6c2ZIYWUwVTFrZTU1M21MQ2UxSWROdm9jbjlFUS84?= =?iso-2022-jp?B?RVl2cERONTdSSWlpNGJiSUFmMXhMQ3dBNE12TlMrbUg0WkI4ZHJKNFVj?= =?iso-2022-jp?B?cEFZc1RXanRHUjI1WkkzNnlEUkVxK0o4enlLTjhTNWpxQTlmUzljQlVn?= =?iso-2022-jp?B?TnBEQnlYZlExSlo1NWdTbDlUKzlmc0UveUtIYllBTWxrdytKbTZGUEVs?= =?iso-2022-jp?B?b09VeldxL2t6Q0FzcGw1dmViazF0cjEvRnRuM01QRExQK2hhTDlNbXBG?= =?iso-2022-jp?B?NGhuZG5VaHhyK2dIT0grZkhvTXNnbHlrdVVWY0h4cTBCc0g4cFF1VUN0?= =?iso-2022-jp?B?UnFFM3dKZGY3UjA0ZDVxU0hyZ3BVU3R4NkhlejRXQ2VFYmZweHE3NjZi?= =?iso-2022-jp?B?a2xuQkdReWJOSElKNDhTRlliMDQ3U0l1eWhTTDlUMWlGVnNNVGZBdXRE?= =?iso-2022-jp?B?VUhpdlVEeDdacG9KOU1TWkM1NHpMTnpxUmcxQXNLR083dnpI?= x-ms-exchange-antispam-messagedata-1: 1OaCwgAhFKMFi0/r1sVXH5hdaDhuEBjxDkA= Content-Type: multipart/related; boundary="_005_YT4P288MB0150006B32BC0AEE934E8ECA837FAYT4P288MB0150CANP_"; 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: d9529ba5-d31f-4d31-fc65-08de790d10ca X-MS-Exchange-CrossTenant-originalarrivaltime: 03 Mar 2026 10:10:15.5983 (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: CZePt4wKHPR0LMls1xGBnkm6AsgiPF3AD3lTdFupVMyLdi2luDe1KQyRjgmvPE4dIc6z6dXWEfHXXoErAzCfGDalWEOoblHKb9bU73R53ydJbAT4E/n28D8ruRt/D/X6 X-MS-Exchange-Transport-CrossTenantHeadersStamped: YT6P288MB0770 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_005_YT4P288MB0150006B32BC0AEE934E8ECA837FAYT4P288MB0150CANP_ Content-Type: multipart/alternative; boundary="_000_YT4P288MB0150006B32BC0AEE934E8ECA837FAYT4P288MB0150CANP_" --_000_YT4P288MB0150006B32BC0AEE934E8ECA837FAYT4P288MB0150CANP_ Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable Adding pgsql-general@lists.postgresql.org +++ Regards, Nandish Bhuva [cid:299ed884-fec4-4f78-a205-4c85638d25c6] ________________________________ From: Nandish Bhuva Sent: Tuesday, March 3, 2026 3:01 PM To: Laurenz Albe Subject: Re: Timezone handling with timestamp without time zone columns @Laurenz Able Thank you for your response and for clarifying that the issue stems from ho= w the timestamps are being stored rather than from PostgreSQL itself. Unfortunately, the application is quite large and complex, and at this time= we are not in a position to modify the column definitions or update the st= ored data. Therefore, we are looking for a solution that allows us to handl= e the timezone conversion purely at the query level using SELECT, without a= ltering the table structure or existing data. As mentioned previously: * empjob_utc_update_date stores UTC values (but is defined as timestamp witho= ut time zone) * jstsk_lst_end_tm stores Canada/Pacific local time (also timestamp without t= ime zone) Our goal is to convert both timestamps to a common timezone (for example, U= TC) within the query itself to ensure accurate comparison. I attempted the following: 1. SELECT (to_timestamp('2026-02-19 01:23:46.016', 'YYYY-MM-DD HH24:MI:SS.FF3') AT TIME ZONE 'Canada/Pacific') AT TIME ZONE 'UTC' AS utc_time; 1. select ej.empjob_utc_update_date , (SELECT jstsk_lst_end_tm AT TIME ZONE 'Canada/Pacific' AT TIME ZONE 'UTC' FROM jobskd_task WHERE jstsk_desc =3D 'ALERT - VCH - Team approver Changes' AND jstsk_deleted =3D 'N' order by jstsk_lst_end_tm desc limit 1) as job_last_run_time from employee_job ej where ej.empjob_utc_update_date >=3D ( SELECT jstsk_lst_end_tm FROM jobskd_task WHERE jstsk_desc =3D 'ALERT - VCH - Team approver Changes' AND jstsk_deleted =3D 'N' limit 1 ) However, the result does not appear to be converting correctly in our actua= l comparison scenario. Could you please advise on the correct way to: 1. Treat empjob_utc_update_date explicitly as UTC 2. Treat jstsk_lst_end_tm explicitly as Canada/Pacific 3. Convert both to the same timezone (e.g., UTC) within a SELECT query 4. Compare them accurately without modifying stored data Your guidance on the proper AT TIME ZONE usage for timestamp without time z= one columns would be greatly appreciated. Thank you again for your assistance. Regards, Nandish Bhuva [cid:cf0a551d-7171-499c-bc85-17b504e00d19] ________________________________ From: Laurenz Albe Sent: Friday, February 27, 2026 8:31 PM To: Nandish Bhuva ; pgsql-general@lists.p= ostgresql.org Subject: Re: Timezone handling with timestamp without time zone columns On Wed, 2026-02-25 at 08:28 +0000, Nandish Bhuva wrote: > I would like to report a timezone-related issue we are encountering in ou= r PostgreSQL database. To avoid misunderstandings: thsi is not a problem of PostgreSQL, but a user= -created problem, right? > 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= comparing > these two timestamps in our queries, we are getting incorrect results 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. To reiterate: *you* are storing the data in the columns in this way. > * Since both columns are defined as timestamp without time zone, Postgre= SQL does not > apply any timezone conversion during comparison, which is leading to l= ogical > inconsistencies. > > We would like clarification on the recommended approach to handle this sc= enario. Specifically: > 1. Should both columns be converted to timestamp with time zone If you are operating only within a single time zone, it doesn't matter. You just have to be consistent about how you store timestamps. > 2. Give me best solution for without even changing the column datatype= . You can fix the incorrectly stored data with UPDATE tab SET empjob_utc_update_date =3D empjob_utc_update_date AT TIME ZONE 'UTC' AT TIME ZONE 'America/Chicago'; That will convert UTC timestamps to Chicago timestamps. > Please advise on the best practice to ensure consistent timezone handling= and accurate > comparisons going forward. The best practice is that you store tmestamps in a consistent fashion: either - use "timestamp with time zone", store timestamps with time zone and make sure that the parameter "timezone" is set correctly in each database session or - use "timestamp without time zone" and store only Chicago timestamps without a time zone Yours, Laurenz Albe --_000_YT4P288MB0150006B32BC0AEE934E8ECA837FAYT4P288MB0150CANP_ Content-Type: text/html; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable
Adding pgsql-general@lists.postgresql.org +++

Regards,
Nandish Bhuva
From: Nandish Bhuva <Nan= dish.bhuva@srmsoftwareinc.com>
Sent: Tuesday, March 3, 2026 3:01 PM
To: Laurenz Albe <laurenz.albe@cybertec.at>
Subject: Re: Timezone handling with timestamp without time zone colu= mns
 
@Laurenz Able

Thank you for your response and for clarifying that the issue stems from ho= w the timestamps are being stored rather than from PostgreSQL itself.
Unfortunately, the application is quite large and complex, and at this time= we are not in a position to modify the column definitions or update the st= ored data. Therefore, we are looking for a solution that allows us to handl= e the timezone conversion purely at the query level using SELECT, without altering the table s= tructure or existing data.
As mentioned previously:
  • empjob_utc_update_date stores UTC values (but is defined = as timestamp without time zone)
  • jstsk_lst_end_tm stores Canada/Pacific local time (also <= code>timestamp without time zone)
Our goal is to convert both timestamps to a common timezone (for example, U= TC) within the query itself to ensure accurate comparison.
I attempted the following:

  1. SELECT
    (to_timestamp('2026-02-19 01:23:46.016',
    'YYYY-MM-DD HH24:MI:SS.FF3')
    AT TIME ZONE 'Canada/Pacific')
    AT TIME ZONE 'UTC' AS utc_time;

  1. select
    ej.empjob_utc_u= pdate_date ,
    (SELECT jsts= k_lst_end_tm AT TIME ZONE 'Canada/Pacific' AT TIME ZONE 'UTC'
    FROM jobskd_tas= k
    WHERE jstsk_des= c =3D 'ALERT - VCH - Team approver Changes'
    AND jstsk_delet= ed =3D 'N'
    order by= jstsk_lst_end_tm desc
    limit 1) as<= /b> job_last_run_time
    from employee_j= ob ej
    where ej= .empjob_utc_update_date >=3D (
    SELECT jstsk_ls= t_end_tm
    FROM jobskd_tas= k
    WHERE jstsk_des= c =3D 'ALERT - VCH - Team approver Changes'
    AND jstsk_delet= ed =3D 'N'
    limit 1
    )

However, the result does not appear to be converting correctly in our actua= l comparison scenario.
Could you please advise on the correct way to:
  1. Treat empjob_utc_update_date explicitly as UTC
  2. Treat jstsk_lst_end_tm explicitly as Canada/Pacific
  3. Convert both to the same timezone (e.g., UTC) within a SELECT&= nbsp;query
  4. Compare them accurately without modifying stored data
Your guidance on the proper AT TIME ZONE usage for = timestamp without time zone columns would be greatly appreciate= d.
Thank you again for your assistance.
Regards,
Nandish Bhuva
From: Laurenz Albe <la= urenz.albe@cybertec.at>
Sent: Friday, February 27, 2026 8:31 PM
To: Nandish Bhuva <Nandish.bhuva@srmsoftwareinc.com>; pgsql-ge= neral@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Timezone handling with timestamp without time zone colu= mns
 
On Wed, 2026-02-25 at 08:28 +0000, Nandish Bhuva= wrote:
> I would like to report a timezone-related issue we are encountering in= our PostgreSQL database.

To avoid misunderstandings: thsi is not a problem of PostgreSQL, but a user= -created
problem, right?

> 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.8= 30811
>  * 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 comparing
> these two timestamps in our queries, we are getting incorrect results = 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.
To reiterate: *you* are storing the data in the columns in this way.

>  * Since both columns are defined as timestamp without time = zone, PostgreSQL does not
>    apply any timezone conversion during comparison, whi= ch is leading to logical
>    inconsistencies.
>
> We would like clarification on the recommended approach to handle this= scenario. Specifically:
>    1. Should both columns be converted to timestam= p with time zone

If you are operating only within a single time zone, it doesn't matter.
You just have to be consistent about how you store timestamps.

>    2. Give me best solution for without even changing t= he column datatype.

You can fix the incorrectly stored data with

  UPDATE tab
  SET empjob_utc_update_date =3D
      empjob_utc_update_date AT TIME ZONE 'UTC'             &nb= sp;            =     AT TIME ZONE 'America/Chicago';

That will convert UTC timestamps to Chicago timestamps.

> Please advise on the best practice to ensure consistent timezone handl= ing and accurate
> comparisons going forward.

The best practice is that you store tmestamps in a consistent fashion:

either

- use "timestamp with time zone", store timestamps with time zone=
  and make sure that the parameter "timezone" is set correct= ly in each
  database session

or

- use "timestamp without time zone" and store only Chicago timest= amps
  without a time zone

Yours,
Laurenz Albe
--_000_YT4P288MB0150006B32BC0AEE934E8ECA837FAYT4P288MB0150CANP_-- --_005_YT4P288MB0150006B32BC0AEE934E8ECA837FAYT4P288MB0150CANP_ Content-Type: image/png; name="Outlook-wnw0kql4.png" Content-Description: Outlook-wnw0kql4.png Content-Disposition: inline; filename="Outlook-wnw0kql4.png"; size=4808; creation-date="Tue, 03 Mar 2026 09:31:58 GMT"; modification-date="Tue, 03 Mar 2026 10:09:43 GMT" Content-ID: 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= --_005_YT4P288MB0150006B32BC0AEE934E8ECA837FAYT4P288MB0150CANP_ Content-Type: image/png; name="Outlook-vgctuoen.png" Content-Description: Outlook-vgctuoen.png Content-Disposition: inline; filename="Outlook-vgctuoen.png"; size=4808; creation-date="Tue, 03 Mar 2026 10:10:15 GMT"; modification-date="Tue, 03 Mar 2026 10:10:15 GMT" Content-ID: <299ed884-fec4-4f78-a205-4c85638d25c6> 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= --_005_YT4P288MB0150006B32BC0AEE934E8ECA837FAYT4P288MB0150CANP_--