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!

Add Hours to Timestamp

Mohammed RafiFeb 1 2024

Hi,

I have two column shift start time and shift end time both are of datatype TIMESTAMP and the format mask is HH24:MI

when the user enter shift start time say 10:00 in the change event dynamic action of shift start time I need to add 4 hours and it should return 14:00

But it returns in error

How can this be fixed please

Comments
Post Details
Added on Feb 1 2024
4 comments
821 views