Its providing me error................................
insert into products_information
values(1,to_timestamp(current_timestamp,'DD-MON-YYYY
HH24:MI:SS'),1200,10,1000,12,1100,10)
/
ERROR: date format picture end before converting entire input string....This is making me nuts... Please Help a bit....
What is the target field type ?
Why you need to convert current_timestamp using to_timestamp ?
Why not use current_timestamp of systimestamp directly.
Target Field is TimeStamp
time stamp is storing the data in format of dd-mm-yyyy hh:mi:ss.f , i dont want .f i just want upto seconds...
I tried both systimestamp and current_timestamp.
If you do not want time factors, why use timestamp for the field.
If only data and time portion is required why not use DATE data type and sysdate only.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.