GeekInterview.com
Series: Subject: Topic:
Question: 373 of 1131

convert date format in Informatica

I have a requirement to convert date format.my requirement is as follows
i hav date column in my source.my source data in date column
v_date
10-11-2006
19-aug-1999
25-dec-05
null
11-5-05
like this
my 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 to send as it is & if in date column if the record is null it has to replace it with sysdate.how can i do?can any one help me out
Asked by: suneetharoy | Member Since Jun-2007 | Asked on: Aug 27th, 2007

View all questions by suneetharoy   View all answers by suneetharoy

Showing Answers 1 - 2 of 2 Answers

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

Yes  1 User has rated as useful.
  
Login to rate this answer.

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

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.