I have in my job properties - Parameters the following:
EXTRACTSTARTDT String 19000101000000000
EXTRACTENDDT String 20060906123746890
Target Table (MSSQL)
Target_column_Name Timestamp 23,3 (Len,Scale)
I am trying the to load the Parameters into the target table by using substring along with stringtotimestamp. However the end part is totally lost cause I am trying to mix server into Px job. Please help to rectify:
Thanks in advance.
Code: Select all
Stringtotimestamp(Substrings(EXTRACTENDDT[1,4]):'-':Substrings(EXTRACTSTARTDT[5,2]):'-':Substrings(EXTRACTSTARTDT[7,2],"D-YMD[4,2,2]"):"00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss")