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!

Adding hours to a Timestamp field

gkthomasAug 14 2015 — edited Aug 14 2015

I have a Date picker field in an Apex form which has a source database column type " TIMESTAMP with TIMEZONE

The field name in the form is P3_OPENED_DATE . This field has default value CURRET_TIMESTAMP

I have another field P3_DUE_DATE for which I am trying to set the default value as 2 hours added to P3_OPENED_DATE

I tried to set the default value for P3_DUE_DATE as a PL/SQL expression :P3_OPENED_DATE+2*(1/24)

But I get an error when run the form.. Can Someone help

I tried the following SQL in Database and it worked fine, But it comes to form field reference it fails.

select To_char(opened_Date,'DD-MON-YYYY HH:MIPM') opened Date,

to_char(opened_date+2*(1/24),'DD-MON-YYYY HH:MIPM') Due Date from Basic_ticketing

This post has been answered by Kiran Pawar on Aug 14 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2015

Added on Aug 14 2015

#apex-discussions

3 comments

5,529 views