Member Avatar for Majestics

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....

Edited by Majestics because: n/a
  • 2 Contributors
  • 3 Replies
  • 149 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

What is the target field type ?
Why you need to convert current_timestamp using to_timestamp ?
Why not use current_timestamp of systimestamp directly.

Member Avatar for Majestics

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.

Member Avatar for debasisdas

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.

Edited by debasisdas because: n/a
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.