Skip to Main Content

SQL & PL/SQL

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!

Date & Time Issue in oracle form

Zeeshan FazalOct 8 2023

My form show date and time is :: 08-10-23 04:00:22 PM (Correct data)

but when data is inserted

database has data like this : 08-OCT-23 11.00.22.000000000 AM (Incorrect data).

i am using this code in oracle form :

:TRANS_CUST.INV_DATE := CURRENT_TIMESTAMP ;

Please help me out i am newbee

Comments
Post Details
Added on Oct 8 2023
12 comments
313 views