How to transform a string into timestamp in DataStage?

Question

I read data from a csv file,and I get a string like "2010-7-3", I can't transform this data into timestamp,because it not like "2010-07-03"

What should I do?Is there a stage could handle this?

Have you tried specifying the date format? Something like `StringToTimestamp(DSLink.MY_STRING_COL,"%yyyy-%m-%d")` ? — Adam Hawkes, Jul 19 '12 at 13:59

score 2 · Accepted Answer · answered Jul 20 '12 at 01:50

2

In the transformer, set up three stage variables - year, month and day. Their respective values should be as follows

Field(InputLink.string_date, "-", 1)
Right("0" : Field(InputLink.string_date, "-", 2), 2)
Right("0" : Field(InputLink.string_date, "-", 3), 2)

Then use this in the output column:

StringToTimestamp(year : month : day : "000000", "%yyyy%mm%dd%hh%nn%ss")

answered Jul 20 '12 at 01:50

lins314159

I use the java stage and handle that problem by java code,I haven't try your solution,but thank you all the same. – wtm Jul 20 '12 at 03:03

1 Answers1