SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hour of CURRENT_DATE is one hour before the real hour

Christian Pitet 2Dec 28 2025 — edited Dec 28 2025

Hi,

Under Oracle APEX, I have an application with a form and an item type date that I calculate the default value with a PL/SQL Expression :

TO_CHAR(CURRENT_DATE, 'DD/MM/YYYY HH24:MI')

But the hour calculated is one hour before the real hour. I am in France. So it display this “28/12/2025 15:56” but it is in reality “28/12/2025 16:56”. How to add one hour to this expression?

Best regards.

This post has been answered by GhanaApexDeveloper on Dec 28 2025

Jump to Answer

Added on Dec 28 2025

#pl-sql

3 comments

100 views

1 mention