need logic for date transformation

[pattemk]

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

[Sudhindra_ps]

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