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!

Default Value Systimestamp

Veerendra PatilFeb 19 2020 — edited Feb 20 2020

Hi,

I am using APEX 19.1 DB 12c

I have a column in a table as updated_date TIMESTAMP (6) DEFAULT systimestamp NOT NULL

In the APEX page, my update_date has below settings

1.png

I set default values as below.

1.png

When I try to save - I get the error as

1.png

I checked the Globalisation settings for the app - Timestamp value is not set there as well

1.png

If I dont give the Format Mask - for the item I get the

1.png

Please suggest how to resolve this.

Thanks,

Veerendra.
Comments
Post Details
Added on Feb 19 2020
#apex-discussions
4 comments
2,776 views