Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IG not storing properly the dates

Hi,

Under APEX 24 I have an intractive Grid on page 12. I enter the dates (DATE_DEBUT) and DATE_FIN with an hour. When I save the IG the dates appear with a hour date set to 00:OO. I don't know why. The mask format of the dates is “DD/MM/YYYY HH24:MI”.

Dates as I set them :

When I save the IG the dates appear with a time set to 00:00 :

The request of the interactive grid is :

select ID,
      DATE_DEBUT,
      DATE_FIN,
      ID_MISSION, DATE_FIN - DATE_DEBUT "Durée (j.)"
 from CY_MISSION_HEURE
where ID_MISSION = :P12_ID

Why does this happen ?

Best regards.
This post has been answered by Christian Pitet 2 on Mar 20 2025
Jump to Answer

Comments

Post Details

Added on Mar 19 2025
#apex-discussions
15 comments
137 views