I have a requirement to convert date format.my requirement is as followsi hav date column in my source.my source data in date columnv_date10-11-200619-aug-199925-dec-05null11-5-05like thismy requirement is,it has to send me the output as dd-mon-yyyy like 26-nov-2006.if in v_date column required format is not there it has to convert it the correct format,if the record is in the correct format it has...

superhero

 Profile Answers by superhero Questions by superhero

• Dec 8th, 2008

IIF(ISNULL(V-date),TO_DATE(SYSDATE, 'dd-mon-yy')IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Sep 13th, 2007

Simple use expression transformation and make all the inputs into the date format given. Add a condition like IIF(ISNULL(V-date),SYSDATE(),IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')This is my idea. It helps you hopefully....thx

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Dont user select */in/write minimal cond

Answer Question  Select Best Answer