Skip to Main Content

APEX

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!

How to display a date with the current hour

Christian Pitet 2Nov 14 2023 — edited Nov 14 2023

Hi,

I have created a form with a date using these parameters :

Type : Date

Default value : PL/SQL Expression

to_char(sysdate, 'DD/MM/YYYY HH24:MI') (thank you @fac586)

Unfortunately, it displays not the current hour, but the hour one hour before. For example if the hour is 19:09, it displays 18:09. I think this is due to the time zone of the database settings. I am in France, how to change the time zone of the database? I am running an “Always free” database.

Best regards.

PS : I tried to change my display name, but could not do it, sorry for this user name

This post has been answered by Dietmar Gabauer-Oracle on Nov 15 2023
Jump to Answer
Comments
Post Details
Added on Nov 14 2023
5 comments
501 views