string to timestamp conversion

[dodda]

Hi,

Iam having a sequential file with following two columns

SHPDATE column with data 20080202 of varchar (8)

SHPTIME column with data 1825 of varchar (4)

Both the columns should be concatenated and map to target column SHPTM of timestamp datatype and data should be of 20080202182500

Please suggest me to solve this one.

Thanks in advance

dodda

[ray.wurlod]

StringToTimestamp() function in Transformer stage. Concatenate your strings as the first argument, and provide an appropriate timestamp format string - depending on what you've done with the strings (for example inserted delimiter characters.