Hi
I had a job like this
===========================
= Sequencefile => Transformer => DB2 =
===========================
one column of source sequence file is '1435668237'
this is seconds
![Sad :(](./images/smilies/icon_sad.gif)
I wanna insert data to target DB2 like this format
'YYYYMMDD'
a method of cacaluation is '1970-1-01 09:00:00' add '1435668237 seconds'
result => YYYYMMDD
I had a solution by SQL query....
but I wanna know a way by DS Function or Routine
![Smile :)](./images/smilies/icon_smile.gif)
Plz give me lessons
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
thanks for reading my topic
![Surprised :o](./images/smilies/icon_surprised.gif)