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,810 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
Similar Questions
+1 vote

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

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++, sample program will help?

+2 votes

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?

...