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