top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica — How to convert 'DD-MON-YY' to DD/MM/YYYY

+2 votes
1,635 views

I am have one date (string) field in the format 'dd-mmm-yy' like ('1-Jan-87'). Now I want to convert it as 'DD/MM/YYYY' like (01/01/1987).

Please help me in this conversion.

posted Aug 19, 2016 by Info Data

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes 
TO_DATE(Column_name, 'dd/mm/yyyy')

Use the above function to covert.

answer Aug 19, 2016 by Salil Agrawal
NO its not working .. any suggestions for data types or properties of transformation?? Source is in string i want target in DateTime datatype
commented Aug 19, 2016 by Info Data
Ideally should work check this reference
http://forgetcode.com/Informatica/466-To-Date-Convert-String-to-Date
commented Aug 19, 2016 by Salil Agrawal
Similar Questions
+1 vote
How to convert the date format 'MM/DD/YY' to 'DD-MMM-YYYY'

I am getting one data filed from one text file at format 'MM/DD/YY'(like '06/13/14'). Now I want to convert it as 'DD-MMM-YYYY' like (13-JUN-2014).

Please help me in this conversion.

+1 vote
I have to fill a drop down in month and last day of each month as, mm/dd. Any idea??

Items in dropdown
01/31
02/28
03/31
04/30
.........

12/31

+3 votes
How to print current date and time in C/C++ ?

How to print current date and time in C/C++, sample program will help?

+2 votes
How to enter a date 01/01/1901 into mysql date field using PHP?

I have a date field on an html form that users may leave blank. If they do leave it blank I want to write the date 01/01/1901 into the mysql table. How can I accomplish this and where in my .php script file should I put the code?

...