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!

How to display/edit timestamp in a Form Field ?

582691Dec 31 2009 — edited Jan 8 2010
Hello,

i have a table which has a TIMESTAMP column and i have a form based on this. What i want is to be able to have a user see it during displaying in a form and be able to insert or modify these timestamp values. I looked through the various DATE pickers in Page Item | Display as, but i didn't find a suitable one for TIMESTAMPs. The closest one to my needs is that of DD/MM/YYYY HH24:MI but if i use it the user can't provide seconds and if form in update mode, when the user presses save without actually making any modifications the seconds part of the field is lost.

Any idea how to solve this situation? Have you had such a similar problem in your implementation? How do you implement in your applications TIMESTAMPS?

TIA

Edited by: Dionyssis on 7 Ιαν 2010 3:12 πμ
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2010
Added on Dec 31 2009
8 comments
1,478 views