DSXchange

i know it is a dumd question but i am having a hard time to transform the date modifications like "2007-04-08 00:00:00"(timestamp) to "20070408"(can be either varchar or any data type).

please help

thanks

hi,

If you are sure that input column is of "Timestamp" data type then you could make use of TimeStamp to string conversion function in Transformer stage or Modifier stage.
Ex: TimestampToString(InputColumn,"%yyyy%mm%dd")

Thanks & regards
Sudhindra P S