I have the below data in a file.
FM001 093011 0.233
I have to store this value in a datetime field column in sql server.
My job design is as below:
SeqFile --> Transformer --> ODBC
SeqFile:
ret_dt VARCHAR(10)
ODBC:
ret_dt TIMESTAMP 23 3
I tried the below codes:
Code: Select all
load_sec_returns.ret_dt[5,6]:'-':load_sec_returns.ret_dt[3,4]:'-':load_sec_returns.ret_dt[1,2]:' 00:00:000'
APT_CombinedOperatorController,1: Data string '11-31-08 00:00:000' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the value for tag %yyyy has fewer characters than expected.
Code: Select all
SV = load_sec_returns.ret_dt[1,2]:'/':load_sec_returns.ret_dt[3,2]:'/':load_sec_returns.ret_dt[5,2]
OCONV(ICONV(StageVar,'D2/'),'D-E')
Can you help me to resolve this issue?