Here's a template of what I've used before that will return it's output as a string in the Oracle To_Timestamp() format. You should be able to adapt this to suit your needs. Oconv(ICONV(Left(ExtractOvrdFile.EVENT_TIME_DTS,10),"D/MDY[2,2,4]"),"D-YMD[4,2,2]") : " " : Ocon...