Skip navigation
Contact Us
1906 Views 5 Replies Latest reply: Dec 27, 2012 10:57 AM by Raghvendra Sharma RSS
Infa Learner Newbie 16 posts since
Nov 1, 2012
Currently Being Moderated

Nov 16, 2012 8:45 AM

Fixed date format in Informatica

Folks,

 

I have an expression which does the below check IIF(IS_DATE(DATESTR1, 'DD-MON-YYYY'), TO_DATE(DATESTR1, 'DD-MON-YYYY'), NULL)

But even if I get an input 07-Nov-12, informatica loads it as 12/07/0012 on an oracle database.

 

In oracle I could have used FXDD-MON-YYYY. Is there a similar soluition in Informatica? Else I will have to do a Length check forst and then convert

 

Thanks,

Sunil

 

  • sasi ramesh Master 1,110 posts since
    Oct 2, 2010
    Currently Being Moderated
    Nov 19, 2012 11:06 PM (in response to Infa Learner)
    Fixed date format in Informatica

    Hi Sunil,

     

    Here you are passing YY for year ,but you are converting it to YYYY.Try changing the expression as below.

     

    IIF(IS_DATE(DATESTR1, 'DD-MON-YY'), TO_DATE(DATESTR1, 'DD-MON-YY'), NULL)

     

     

    Regards

    Sasiramesh

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points