Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Updating a Date column via a APEX form, with Time

Robert VeitchNov 9 2023 — edited Nov 9 2023

Having a issue with trying to update a date value with time from an APEX form.

My DB datatype for START_DT is a Date.

I have a form that gets its values from an IG, and the field that I'm having issues with is START_DT.

In this example the value of the data for P7_START_DT is 11/09/2023 01:07:14 PM

I've tried this with no luck.

START_DT = to_date(:P7_START_DT,'MM/DD/YYYY HH:MI:SS AM')

I get the following error, ORA-01830: date format picture ends before converting entire input string

I checked and I have no option to change the data type in APEX to a Datetime in the form? Here are my options, see screenshot.

I've tried DatePicker or TextField with the same results.

I've tested with the data for START_DT as just a date with the value of the data for START_DT as this 11/09/2023 and it works fine:

START_DT = :P7_START_DT

Thanks for any help.

Bob

This post has been answered by Robert Veitch on Dec 1 2023
Jump to Answer
Comments
Post Details
Added on Nov 9 2023
4 comments
159 views