Date datatype conversion
Posted: Sun Nov 20, 2011 11:07 pm
Hi,
I reading from Oracle database and loading into sequecial file.
From Oracle source Date is coming as
21-03-11
15-04-00
16-11-81
and we need output as
21-03-2011
15-04-2000
16-11-1981
I am trying to function StringtoDate(Columnname,"%dd-%mm-%yyyy").
But its not getting converted in required format.
Please suggest if I am using wrong derivation.
Thanks.
I reading from Oracle database and loading into sequecial file.
From Oracle source Date is coming as
21-03-11
15-04-00
16-11-81
and we need output as
21-03-2011
15-04-2000
16-11-1981
I am trying to function StringtoDate(Columnname,"%dd-%mm-%yyyy").
But its not getting converted in required format.
Please suggest if I am using wrong derivation.
Thanks.