StringtoTimestamp

[kashif007]

TgtAgentLoad,1: Failure during execution of operator logic.
TgtAgentLoad,1: Fatal Error: Invalid Julian day

I get the above error when I try to load a table into an oracle database before the job gets aborted. Following is the conversion I am doing on the date field.

StringToTimestamp(lnkAgentInLoad.LIC_EXPIRTON_DT: "00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss")

My conversion seems correct but there is something missing in my job that gets its aborted due to the date field. Can any one tell me what do I do.

[nick.bond]

StringToTimestamp(lnkAgentInLoad.LIC_EXPIRTON_DT: "00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss")

have you missed a space before 00:00:00

Code: Select all

StringToTimestamp(lnkAgentInLoad.LIC_EXPIRTON_DT: " 00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss")