Skip to Main Content
Forums

Oracle Forms

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!

save date with timestamp in date column via forms

User_KVV1COct 16 2018 — edited Oct 16 2018

Hi All,

Need Your help.

my scenario is i have a table with date column and I want to insert date with timestamp in this column via forms.

I am using below code but only Date with 16-OCT-0018 00:00:00 is getting saved in table.

:Block.item_DATETIME := to_date(SYSDATE,'DD-MON-YYYY HH24:MI:SS');

Regards,

Balaji
This post has been answered by Michael Ferrante-Oracle on Oct 16 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2023
Added on Oct 16 2018
#forms, #moved-from-devops
5 comments
6,610 views
1 mention