DSXchange

Hi i have to load data from One xml file to database i am using sequential file ---> xml input stage ----> oracle stage first i am taking all the cols into one colmn(in sequential file) then in xml input stage under output tab i am providing the correct path for all the colms while running i am gett...

satishm wrote:Hi,
Can some one assist in converting a date from one format to another.

eg:
Input Date : 2009-12-31 ( yyyy-mm-dd) data-type : Date

Output Required : 31-12-2009 ( dd-mm-yyyy) data-type : Date

Regards,
SatishM.

you can convert first date to string then and then again string to date