Problem in String to Date conversion
Posted: Mon Jun 09, 2008 1:33 am
Hi Experts,
I am trying to convert an input column coming as varchar to Date format.
The input is coming in the format "mm/dd/yy 00:00:0"
I have used the combination of below functions in transformer.
StringToDate(Convert( "0:00:00","", LNK_XFRM_REAL_EST_STORES_DM.store_open_date) ,"%mm-%dd-%yyyy")
and I am getting the column as ******* in peek stage.
And when I am trying to load the database (Netezza) I am gettng the error
main_program: Fatal Error: Added field has duplicate identifier():
I have tried out all possible methods.. Can somebody help me out to get around this.. ?
Thanks in Advance.
I am trying to convert an input column coming as varchar to Date format.
The input is coming in the format "mm/dd/yy 00:00:0"
I have used the combination of below functions in transformer.
StringToDate(Convert( "0:00:00","", LNK_XFRM_REAL_EST_STORES_DM.store_open_date) ,"%mm-%dd-%yyyy")
and I am getting the column as ******* in peek stage.
And when I am trying to load the database (Netezza) I am gettng the error
main_program: Fatal Error: Added field has duplicate identifier():
I have tried out all possible methods.. Can somebody help me out to get around this.. ?
Thanks in Advance.