Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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
5 comments
5,594 views