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.

commented: Truly Amazing.... +7
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.