I have a datefield (01/25/2008) stored as a Varchar. I need to convert it into Timestamp 19 format with hh:mm:ss as 00:00:00. I went through different threads and tried different things. Everytime i get ***** as out put. Can anyone please help me? Thanks in advance.
It's like ArndW said, your job/project format default settings have the timestamp format of day then month (%dd/%mm) You can either change them to be month then day (%mm/%dd) or you can explicitly state the format of your date field in the transformer like ArndW previously posted.