How to choose a timestamp data type value from a LOV in Oracle APEX

265 Views Asked by At

See imagehttps://i.stack.imgur.com/BSlpn.jpg

What is a simple way to insert timestamp values in my setup?

The LOV right now exists of static content, I just filled in the '10:00' manually.

Still a noob so I'm sorry if this is very obvious.

1

There are 1 best solutions below

3
EJ Egyed On BEST ANSWER

In the APEX page designer, after selecting your Tijd field, you need to set the format mask that matches the format of the Return Value of your LOV. I created a quick demo application that shows the difference between using a format mask and not using a format mask.

enter image description here

This is what my LOV definition looks like:

enter image description here