Oracle Database 19.18.0.0.0

Hi,

Oracle Database Version : 19.18.0.0.0

OS version :Oracle Linux Server release 7.9

We are facing some issues with timestamp especially in Mexico time zone. Below query executed in sql developer shows different result.

whereas Same query shows perfectly fine in SQL plus. Kindly suggest fixing the same.

FILENAME      Version

---------------------------

timezlrg_41.dat   41

PROPERTY_NAME         PROPERTY_VALUE

----------------------------------------------

DST_PRIMARY_TT_VERSION    41

DST_SECONDARY_TT_VERSION   0

DST_UPGRADE_STATE       NONE

Sqldeveloper:-

Query:-

select cast(date'2023-03-03' as timestamp) at time zone 'UTC' d1,

cast(date'2023-03-03' as timestamp) at time zone 'America/Mexico_City' d2

from dual union all