Look at your data, your data doesn't match your to_timestamp() format.
Look at the example on previous posting.
Fix your syntax.
Printable View
Look at your data, your data doesn't match your to_timestamp() format.
Look at the example on previous posting.
Fix your syntax.
Could you please guide me where excatly my data doesnt match
If u r talking abt the TO_timestamp functon ..that i used(start_date,dd-mon-yy hh24:mi:ss:fff') tooo..if its not please let me know..
i know I might be doin some sily mistake....
I 'll folow ur statement howver my database is facing some issue..so as soon it gets recitfy i 'll let u know...
Himanshu
Not trying to be rude, if you can't follow this instructions...
... I'll be tempted to give up on you.Quote:
Originally Posted by PAVB
Hey ,,If u dont mind Can I knw ur Name?
I appologize for not looking at ur example carefully which agonised u.
Howevr I followed and it worked sucessfully.Here is the code that I used
UPDATE STAGING_CONTRACT
SET EFFECT_DATE = TO_TIMESTAMP(SUBSTR(START_DATE,1,18),'DD-MON-YY HH24:MI:SS')
,EXPIRE_DATE = TO_TIMESTAMP(SUBSTR(END_DATE,1,18),'DD-MON-YY HH24:MI:SS')
I m really Thankful to you.This litle stuff was like a pain in my neck....but now its a useful learning too for me.....
Himanshu
I'm glad it worked out.
--Can I Knw your name so that I cane remebr always....
One more thing have you ever worked on DBMS_Scheduler?
Himanshu
Around here most people calls me "Ivan le russe fou" which is a cute wording for "Ivan the crazy russian".
Yes.
Ivan I m new in PL/SQL..but still able to get workaround luckily..jus because of such knowledge filled Forums.
Now the problem is we've been asked to use dbms_scheduler whose task will be to run a shel script which will call other sqls for processing...
The workng of scheduler is to call Linux M/C remotely..so if u have any basic knowledge how to do it?Please let me know
-Himanshu
You have to open a new thread
I 'll do dat