How to convert below Timestamp from Sequential File to Oracle Format using Transformer stage.
Input Fomrat ; 11/1/2016 4:26:52 PM
Conversion :
StringToTimestamp(Tx.DateTime,"%(m,s)-%(d,s)-%yyyy %(H,s):%(n,s):%(s,s) %aa")
Output Format : 2016-11-01 16:26:52
Source:
http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/r_deeadvrf_time_Formats.html
Input Fomrat ; 11/1/2016 4:26:52 PM
Conversion :
StringToTimestamp(Tx.DateTime,"%(m,s)-%(d,s)-%yyyy %(H,s):%(n,s):%(s,s) %aa")
Output Format : 2016-11-01 16:26:52
Source:
http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/r_deeadvrf_time_Formats.html
0 comments:
Post a Comment