public inbox for [email protected]  

help / color / mirror / Atom feed

From: Nandish Bhuva <[email protected]>
To: [email protected] <[email protected]>
Subject: Timezone handling with timestamp without time zone columns
Date: Wed, 25 Feb 2026 08:28:28 +0000
Message-ID: <YT4P288MB01507D63F23F6B505AEB759E8375A@YT4P288MB0150.CANP288.PROD.OUTLOOK.COM> (raw)

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 → 2026-02-19 06:26:23.830811
  *
jstsk_lst_end_tm → 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.
  *
Since both columns are defined as timestamp without time zone, PostgreSQL does not apply any timezone conversion during comparison, which 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 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 and accurate comparisons going forward.
Thanks in advance for your support.


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


Attachments:

  [image/png] Outlook-bfpeekv4.png (4.7K, 3-Outlook-bfpeekv4.png)
  download | view image

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Timezone handling with timestamp without time zone columns
  In-Reply-To: <YT4P288MB01507D63F23F6B505AEB759E8375A@YT4P288MB0150.CANP288.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox