Name Examination: Consider timezone when updating NR expiration date

[eve-git]

There is an issue encountered when updating the expiry date of an existing NR. During synchronization with Oracle, the date in the PostgreSQL "namex" database is copied to the Oracle "namesp" database without undergoing any conversion to the local time. As a consequence, the expiry date in the Oracle database is one day ahead of the expected value.

A modernization developer will need to change the code that updates existing expiry dates as follows:
select expiration_date at time zone 'America/Vancouver' from requests

More details please reference to
#17475

[eve-git]

summary_temp.xlsx

[ozamani9gh]

@iamjtodd i am bumping the priority up to 1 on this one, because its related to an ops ticket and related to this ticket here:
https://app.zenhub.com/workspaces/ops-60f8556e05d25b0011468870/issues/gh/bcgov-registries/ops-support/3126
and

urgent ticket 17475.

please let me know if you want to discuss

[eve-git]

I don't know how to check NR in COLIN... But I can provide you the data in Oracle db after updating NR expiration date. Let me know if I can be help.

[eve-git]

Deployed to test environment and ready to test

[oanyahuru]

Comments related to this ticket have been updated on #18301